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_REQUEST_APR_PVT dependencies on FND_MESSAGE

Line 173: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

169: IF (c_fund_detail%NOTFOUND) THEN
170: CLOSE c_fund_detail;
171:
172: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
173: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
174: fnd_msg_pub.add;
175: END IF;
176:
177: RAISE fnd_api.g_exc_error;

Line 192: fnd_message.set_name('OZF', 'OZF_AMT_UNAVAILABLE');

188: NVL(l_source_rec.committed_amt, 0)
189: ,0)) <
190: p_approved_amount THEN
191: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
192: fnd_message.set_name('OZF', 'OZF_AMT_UNAVAILABLE');
193: fnd_msg_pub.add;
194: END IF;
195:
196: RAISE fnd_api.g_exc_error;

Line 207: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

203: IF (c_to_fund_currency%NOTFOUND) THEN
204: CLOSE c_to_fund_currency;
205:
206: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
207: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
208: fnd_msg_pub.add;
209: END IF;
210:
211: RAISE fnd_api.g_exc_error;

Line 276: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

272: IF (c_target_fund_detail%NOTFOUND) THEN
273: CLOSE c_target_fund_detail;
274:
275: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
276: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
277: fnd_msg_pub.add;
278: END IF;
279:
280: RAISE fnd_api.g_exc_error;

Line 341: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

337: IF (c_act_budget_detail%NOTFOUND) THEN
338: CLOSE c_act_budget_detail;
339:
340: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
341: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
342: fnd_msg_pub.add;
343: END IF;
344:
345: RAISE fnd_api.g_exc_error;

Line 411: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

407: IF (c_act_budget_detail%NOTFOUND) THEN
408: CLOSE c_act_budget_detail;
409:
410: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
411: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
412: fnd_msg_pub.add;
413: END IF;
414:
415: RAISE fnd_api.g_exc_error;

Line 605: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

601: IF (c_target_fund_detail%NOTFOUND) THEN
602: CLOSE c_target_fund_detail;
603:
604: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
605: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
606: fnd_msg_pub.add;
607: END IF;
608:
609: RAISE fnd_api.g_exc_error;

Line 676: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

672: IF (c_act_budget_detail%NOTFOUND) THEN
673: CLOSE c_act_budget_detail;
674:
675: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
676: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
677: fnd_msg_pub.add;
678: END IF;
679:
680: RAISE fnd_api.g_exc_error;

Line 741: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

737: IF (c_act_budget_detail%NOTFOUND) THEN
738: CLOSE c_act_budget_detail;
739:
740: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
741: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
742: fnd_msg_pub.add;
743: END IF;
744:
745: RAISE fnd_api.g_exc_error;

Line 1002: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

998: IF (c_parent_fund_owner%NOTFOUND) THEN
999: CLOSE c_parent_fund_owner;
1000:
1001: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1002: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1003: fnd_msg_pub.add;
1004: END IF;
1005:
1006: RAISE fnd_api.g_exc_error;

Line 1031: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

1027: IF (c_fm_fund_currency%NOTFOUND) THEN
1028: CLOSE c_fm_fund_currency;
1029:
1030: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1031: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1032: fnd_msg_pub.add;
1033: END IF;
1034:
1035: RAISE fnd_api.g_exc_error;

Line 1046: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

1042: IF (c_to_fund_currency%NOTFOUND) THEN
1043: CLOSE c_to_fund_currency;
1044:
1045: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1046: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1047: fnd_msg_pub.add;
1048: END IF;
1049:
1050: RAISE fnd_api.g_exc_error;

Line 1082: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

1078: IF (c_act_budget_rec%NOTFOUND) THEN
1079: CLOSE c_act_budget_rec;
1080:
1081: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1082: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1083: fnd_msg_pub.add;
1084: END IF;
1085:
1086: RAISE fnd_api.g_exc_error;

Line 1325: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_FYI_SUB');

1321: ,aname => 'AMS_APPROVER_DISPLAY_NAME');
1322: OPEN c_act_budget_rec(l_act_budget_id);
1323: FETCH c_act_budget_rec INTO l_request_rec;
1324: CLOSE c_act_budget_rec;
1325: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_FYI_SUB');
1326: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1327: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1328: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1329: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);

Line 1326: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);

1322: OPEN c_act_budget_rec(l_act_budget_id);
1323: FETCH c_act_budget_rec INTO l_request_rec;
1324: CLOSE c_act_budget_rec;
1325: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_FYI_SUB');
1326: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1327: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1328: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1329: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1330: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

Line 1327: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

1323: FETCH c_act_budget_rec INTO l_request_rec;
1324: CLOSE c_act_budget_rec;
1325: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_FYI_SUB');
1326: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1327: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1328: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1329: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1330: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1331: l_string := fnd_message.get;

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

1324: CLOSE c_act_budget_rec;
1325: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_FYI_SUB');
1326: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1327: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1328: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1329: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1330: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1331: l_string := fnd_message.get;
1332: wf_engine.setitemattrtext(

Line 1329: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);

1325: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_FYI_SUB');
1326: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1327: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1328: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1329: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1330: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1331: l_string := fnd_message.get;
1332: wf_engine.setitemattrtext(
1333: itemtype => l_item_type

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

1326: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1327: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1328: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1329: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1330: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1331: l_string := fnd_message.get;
1332: wf_engine.setitemattrtext(
1333: itemtype => l_item_type
1334: ,itemkey => l_item_key

Line 1331: l_string := fnd_message.get;

1327: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1328: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1329: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1330: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1331: l_string := fnd_message.get;
1332: wf_engine.setitemattrtext(
1333: itemtype => l_item_type
1334: ,itemkey => l_item_key
1335: ,aname => 'FYI_SUBJECT'

Line 1337: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');

1333: itemtype => l_item_type
1334: ,itemkey => l_item_key
1335: ,aname => 'FYI_SUBJECT'
1336: ,avalue => l_string);
1337: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1338: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1339: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1340: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1341: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);

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

1334: ,itemkey => l_item_key
1335: ,aname => 'FYI_SUBJECT'
1336: ,avalue => l_string);
1337: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1338: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1339: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1340: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1341: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1342: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);

Line 1339: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);

1335: ,aname => 'FYI_SUBJECT'
1336: ,avalue => l_string);
1337: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1338: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1339: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1340: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1341: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1342: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1343: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);

Line 1340: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);

1336: ,avalue => l_string);
1337: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1338: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1339: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1340: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1341: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1342: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1343: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1344: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);

Line 1341: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);

1337: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1338: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1339: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1340: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1341: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1342: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1343: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1344: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1345: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);

Line 1342: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);

1338: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1339: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1340: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1341: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1342: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1343: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1344: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1345: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1346: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);

Line 1343: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);

1339: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1340: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1341: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1342: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1343: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1344: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1345: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1346: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1347: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);

Line 1344: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);

1340: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1341: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1342: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1343: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1344: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1345: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1346: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1347: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1348: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

Line 1345: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);

1341: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1342: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1343: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1344: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1345: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1346: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1347: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1348: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1349: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);

Line 1346: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);

1342: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1343: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1344: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1345: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1346: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1347: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1348: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1349: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1350: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);

Line 1347: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);

1343: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1344: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1345: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1346: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1347: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1348: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1349: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1350: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1351: l_reason_meaning :=

Line 1348: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

1344: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1345: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1346: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1347: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1348: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1349: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1350: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1351: l_reason_meaning :=
1352: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);

Line 1349: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);

1345: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1346: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1347: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1348: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1349: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1350: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1351: l_reason_meaning :=
1352: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1353: fnd_message.set_token('REASON', l_reason_meaning, FALSE);

Line 1350: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);

1346: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1347: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1348: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1349: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1350: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1351: l_reason_meaning :=
1352: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1353: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1354: l_string1 := fnd_message.get;

Line 1353: fnd_message.set_token('REASON', l_reason_meaning, FALSE);

1349: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1350: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1351: l_reason_meaning :=
1352: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1353: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1354: l_string1 := fnd_message.get;
1355:
1356: l_note := wf_engine.getitemattrtext(
1357: itemtype => l_item_type

Line 1354: l_string1 := fnd_message.get;

1350: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1351: l_reason_meaning :=
1352: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1353: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1354: l_string1 := fnd_message.get;
1355:
1356: l_note := wf_engine.getitemattrtext(
1357: itemtype => l_item_type
1358: ,itemkey => l_item_key

Line 1517: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_APP_SUB');

1513:
1514: OPEN c_act_budget_rec(l_act_budget_id);
1515: FETCH c_act_budget_rec INTO l_request_rec;
1516: CLOSE c_act_budget_rec;
1517: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_APP_SUB');
1518: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1519: -- fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1520: -- fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1521: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);

Line 1518: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);

1514: OPEN c_act_budget_rec(l_act_budget_id);
1515: FETCH c_act_budget_rec INTO l_request_rec;
1516: CLOSE c_act_budget_rec;
1517: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_APP_SUB');
1518: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1519: -- fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1520: -- fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1521: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1522: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

Line 1519: -- fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

1515: FETCH c_act_budget_rec INTO l_request_rec;
1516: CLOSE c_act_budget_rec;
1517: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_APP_SUB');
1518: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1519: -- fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1520: -- fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1521: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1522: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1523: l_string := fnd_message.get;

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

1516: CLOSE c_act_budget_rec;
1517: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_APP_SUB');
1518: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1519: -- fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1520: -- fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1521: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1522: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1523: l_string := fnd_message.get;
1524: wf_engine.setitemattrtext(

Line 1521: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);

1517: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_APP_SUB');
1518: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1519: -- fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1520: -- fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1521: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1522: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1523: l_string := fnd_message.get;
1524: wf_engine.setitemattrtext(
1525: itemtype => l_item_type

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

1518: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1519: -- fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1520: -- fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1521: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1522: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1523: l_string := fnd_message.get;
1524: wf_engine.setitemattrtext(
1525: itemtype => l_item_type
1526: ,itemkey => l_item_key

Line 1523: l_string := fnd_message.get;

1519: -- fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1520: -- fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1521: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1522: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1523: l_string := fnd_message.get;
1524: wf_engine.setitemattrtext(
1525: itemtype => l_item_type
1526: ,itemkey => l_item_key
1527: ,aname => 'APRV_SUBJECT'

Line 1529: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');

1525: itemtype => l_item_type
1526: ,itemkey => l_item_key
1527: ,aname => 'APRV_SUBJECT'
1528: ,avalue => l_string);
1529: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1530: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1531: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1532: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1533: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);

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

1526: ,itemkey => l_item_key
1527: ,aname => 'APRV_SUBJECT'
1528: ,avalue => l_string);
1529: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1530: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1531: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1532: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1533: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1534: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);

Line 1531: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);

1527: ,aname => 'APRV_SUBJECT'
1528: ,avalue => l_string);
1529: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1530: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1531: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1532: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1533: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1534: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1535: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);

Line 1532: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);

1528: ,avalue => l_string);
1529: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1530: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1531: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1532: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1533: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1534: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1535: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1536: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);

Line 1533: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);

1529: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1530: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1531: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1532: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1533: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1534: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1535: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1536: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1537: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);

Line 1534: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);

1530: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1531: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1532: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1533: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1534: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1535: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1536: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1537: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1538: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);

Line 1535: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);

1531: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1532: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1533: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1534: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1535: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1536: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1537: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1538: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1539: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);

Line 1536: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);

1532: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1533: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1534: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1535: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1536: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1537: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1538: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1539: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1540: -- commented on 10/22/2001 mpande

Line 1537: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);

1533: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1534: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1535: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1536: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1537: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1538: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1539: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1540: -- commented on 10/22/2001 mpande
1541: -- yzhao: 01/23/2003 uncomment following 2 lines as tokens are defined in message

Line 1538: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);

1534: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1535: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1536: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1537: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1538: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1539: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1540: -- commented on 10/22/2001 mpande
1541: -- yzhao: 01/23/2003 uncomment following 2 lines as tokens are defined in message
1542: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

Line 1539: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);

1535: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1536: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1537: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1538: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1539: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1540: -- commented on 10/22/2001 mpande
1541: -- yzhao: 01/23/2003 uncomment following 2 lines as tokens are defined in message
1542: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1543: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);

Line 1542: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

1538: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1539: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1540: -- commented on 10/22/2001 mpande
1541: -- yzhao: 01/23/2003 uncomment following 2 lines as tokens are defined in message
1542: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1543: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1544: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1545: l_reason_meaning :=
1546: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);

Line 1543: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);

1539: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1540: -- commented on 10/22/2001 mpande
1541: -- yzhao: 01/23/2003 uncomment following 2 lines as tokens are defined in message
1542: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1543: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1544: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1545: l_reason_meaning :=
1546: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1547: fnd_message.set_token('REASON', l_reason_meaning, FALSE);

Line 1544: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);

1540: -- commented on 10/22/2001 mpande
1541: -- yzhao: 01/23/2003 uncomment following 2 lines as tokens are defined in message
1542: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1543: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1544: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1545: l_reason_meaning :=
1546: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1547: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1548: l_string1 := fnd_message.get;

Line 1547: fnd_message.set_token('REASON', l_reason_meaning, FALSE);

1543: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1544: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1545: l_reason_meaning :=
1546: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1547: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1548: l_string1 := fnd_message.get;
1549: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_ADDENDUM');
1550: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1551: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

Line 1548: l_string1 := fnd_message.get;

1544: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1545: l_reason_meaning :=
1546: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1547: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1548: l_string1 := fnd_message.get;
1549: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_ADDENDUM');
1550: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1551: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1552: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);

Line 1549: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_ADDENDUM');

1545: l_reason_meaning :=
1546: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1547: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1548: l_string1 := fnd_message.get;
1549: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_ADDENDUM');
1550: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1551: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1552: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1553: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL

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

1546: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1547: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1548: l_string1 := fnd_message.get;
1549: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_ADDENDUM');
1550: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1551: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1552: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1553: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL
1554: fnd_message.set_token('NOTES_FROM_APPROVER', l_note, FALSE); */

Line 1551: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

1547: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1548: l_string1 := fnd_message.get;
1549: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_ADDENDUM');
1550: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1551: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1552: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1553: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL
1554: fnd_message.set_token('NOTES_FROM_APPROVER', l_note, FALSE); */
1555: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);

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

1548: l_string1 := fnd_message.get;
1549: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_ADDENDUM');
1550: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1551: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1552: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1553: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL
1554: fnd_message.set_token('NOTES_FROM_APPROVER', l_note, FALSE); */
1555: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);
1556: l_string2 := fnd_message.get;

Line 1554: fnd_message.set_token('NOTES_FROM_APPROVER', l_note, FALSE); */

1550: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1551: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1552: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1553: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL
1554: fnd_message.set_token('NOTES_FROM_APPROVER', l_note, FALSE); */
1555: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);
1556: l_string2 := fnd_message.get;
1557: /*
1558: l_note := wf_engine.getitemattrtext(

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

1551: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1552: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1553: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL
1554: fnd_message.set_token('NOTES_FROM_APPROVER', l_note, FALSE); */
1555: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);
1556: l_string2 := fnd_message.get;
1557: /*
1558: l_note := wf_engine.getitemattrtext(
1559: itemtype => l_item_type

Line 1556: l_string2 := fnd_message.get;

1552: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1553: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL
1554: fnd_message.set_token('NOTES_FROM_APPROVER', l_note, FALSE); */
1555: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);
1556: l_string2 := fnd_message.get;
1557: /*
1558: l_note := wf_engine.getitemattrtext(
1559: itemtype => l_item_type
1560: ,itemkey => l_item_key

Line 1704: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');

1700: ,aname => 'AMS_APPROVER');
1701: OPEN c_act_budget_rec(l_act_budget_id);
1702: FETCH c_act_budget_rec INTO l_request_rec;
1703: CLOSE c_act_budget_rec;
1704: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');
1705: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1706: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1707: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1708: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);

Line 1705: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);

1701: OPEN c_act_budget_rec(l_act_budget_id);
1702: FETCH c_act_budget_rec INTO l_request_rec;
1703: CLOSE c_act_budget_rec;
1704: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');
1705: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1706: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1707: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1708: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1709: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

Line 1706: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

1702: FETCH c_act_budget_rec INTO l_request_rec;
1703: CLOSE c_act_budget_rec;
1704: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');
1705: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1706: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1707: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1708: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1709: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1710: l_string := fnd_message.get;

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

1703: CLOSE c_act_budget_rec;
1704: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');
1705: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1706: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1707: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1708: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1709: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1710: l_string := fnd_message.get;
1711: wf_engine.setitemattrtext(

Line 1708: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);

1704: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');
1705: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1706: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1707: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1708: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1709: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1710: l_string := fnd_message.get;
1711: wf_engine.setitemattrtext(
1712: itemtype => l_item_type

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

1705: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1706: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1707: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1708: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1709: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1710: l_string := fnd_message.get;
1711: wf_engine.setitemattrtext(
1712: itemtype => l_item_type
1713: ,itemkey => l_item_key

Line 1710: l_string := fnd_message.get;

1706: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1707: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1708: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1709: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1710: l_string := fnd_message.get;
1711: wf_engine.setitemattrtext(
1712: itemtype => l_item_type
1713: ,itemkey => l_item_key
1714: ,aname => 'REJECT_SUBJECT'

Line 1716: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');

1712: itemtype => l_item_type
1713: ,itemkey => l_item_key
1714: ,aname => 'REJECT_SUBJECT'
1715: ,avalue => l_string);
1716: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1717: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1718: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1719: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1720: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);

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

1713: ,itemkey => l_item_key
1714: ,aname => 'REJECT_SUBJECT'
1715: ,avalue => l_string);
1716: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1717: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1718: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1719: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1720: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1721: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);

Line 1718: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);

1714: ,aname => 'REJECT_SUBJECT'
1715: ,avalue => l_string);
1716: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1717: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1718: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1719: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1720: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1721: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1722: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);

Line 1719: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);

1715: ,avalue => l_string);
1716: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1717: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1718: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1719: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1720: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1721: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1722: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1723: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);

Line 1720: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);

1716: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1717: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1718: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1719: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1720: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1721: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1722: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1723: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1724: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);

Line 1721: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);

1717: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1718: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1719: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1720: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1721: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1722: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1723: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1724: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1725: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);

Line 1722: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);

1718: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1719: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1720: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1721: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1722: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1723: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1724: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1725: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1726: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);

Line 1723: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);

1719: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1720: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1721: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1722: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1723: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1724: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1725: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1726: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1727: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

Line 1724: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);

1720: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1721: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1722: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1723: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1724: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1725: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1726: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1727: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1728: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);

Line 1725: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);

1721: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1722: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1723: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1724: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1725: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1726: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1727: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1728: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1729: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);

Line 1726: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);

1722: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1723: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1724: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1725: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1726: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1727: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1728: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1729: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1730: l_reason_meaning :=

Line 1727: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

1723: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1724: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1725: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1726: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1727: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1728: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1729: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1730: l_reason_meaning :=
1731: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);

Line 1728: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);

1724: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1725: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1726: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1727: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1728: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1729: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1730: l_reason_meaning :=
1731: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1732: fnd_message.set_token('REASON', l_reason_meaning, FALSE);

Line 1729: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);

1725: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1726: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1727: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1728: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1729: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1730: l_reason_meaning :=
1731: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1732: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1733: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);

Line 1732: fnd_message.set_token('REASON', l_reason_meaning, FALSE);

1728: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1729: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1730: l_reason_meaning :=
1731: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1732: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1733: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1734: l_string1 := fnd_message.get;
1735: /*
1736: l_note := wf_engine.getitemattrtext(

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

1729: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1730: l_reason_meaning :=
1731: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1732: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1733: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1734: l_string1 := fnd_message.get;
1735: /*
1736: l_note := wf_engine.getitemattrtext(
1737: itemtype => l_item_type

Line 1734: l_string1 := fnd_message.get;

1730: l_reason_meaning :=
1731: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1732: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1733: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1734: l_string1 := fnd_message.get;
1735: /*
1736: l_note := wf_engine.getitemattrtext(
1737: itemtype => l_item_type
1738: ,itemkey => l_item_key

Line 1756: fnd_message.set_name ('OZF', 'OZF_WF_NTF_APPROVER_NOTE');

1752: itemtype=> l_item_type,
1753: itemkey=> l_item_key,
1754: aname => 'APPROVAL_NOTE'
1755: );
1756: fnd_message.set_name ('OZF', 'OZF_WF_NTF_APPROVER_NOTE');
1757: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);
1758: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);
1759: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVer's NOTE NOT SHOWING IN rejection EMAIL */
1760:

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

1753: itemkey=> l_item_key,
1754: aname => 'APPROVAL_NOTE'
1755: );
1756: fnd_message.set_name ('OZF', 'OZF_WF_NTF_APPROVER_NOTE');
1757: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);
1758: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);
1759: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVer's NOTE NOT SHOWING IN rejection EMAIL */
1760:
1761: -- IF (display_type = 'text/plain') THEN

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

1754: aname => 'APPROVAL_NOTE'
1755: );
1756: fnd_message.set_name ('OZF', 'OZF_WF_NTF_APPROVER_NOTE');
1757: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);
1758: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);
1759: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVer's NOTE NOT SHOWING IN rejection EMAIL */
1760:
1761: -- IF (display_type = 'text/plain') THEN
1762: l_rej_notification :=

Line 1894: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');

1890: ,aname => 'AMS_APPROVER_DISPLAY_NAME');
1891: OPEN c_act_budget_rec(l_act_budget_id);
1892: FETCH c_act_budget_rec INTO l_request_rec;
1893: CLOSE c_act_budget_rec;
1894: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
1895: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1896: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1897: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1898: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);

Line 1895: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);

1891: OPEN c_act_budget_rec(l_act_budget_id);
1892: FETCH c_act_budget_rec INTO l_request_rec;
1893: CLOSE c_act_budget_rec;
1894: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
1895: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1896: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1897: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1898: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1899: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

Line 1896: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

1892: FETCH c_act_budget_rec INTO l_request_rec;
1893: CLOSE c_act_budget_rec;
1894: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
1895: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1896: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1897: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1898: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1899: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1900: l_string := fnd_message.get;

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

1893: CLOSE c_act_budget_rec;
1894: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
1895: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1896: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1897: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1898: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1899: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1900: l_string := fnd_message.get;
1901: wf_engine.setitemattrtext(

Line 1898: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);

1894: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
1895: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1896: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1897: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1898: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1899: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1900: l_string := fnd_message.get;
1901: wf_engine.setitemattrtext(
1902: itemtype => l_item_type

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

1895: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1896: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1897: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1898: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1899: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1900: l_string := fnd_message.get;
1901: wf_engine.setitemattrtext(
1902: itemtype => l_item_type
1903: ,itemkey => l_item_key

Line 1900: l_string := fnd_message.get;

1896: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1897: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1898: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1899: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1900: l_string := fnd_message.get;
1901: wf_engine.setitemattrtext(
1902: itemtype => l_item_type
1903: ,itemkey => l_item_key
1904: ,aname => 'APP_SUBJECT'

Line 1906: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');

1902: itemtype => l_item_type
1903: ,itemkey => l_item_key
1904: ,aname => 'APP_SUBJECT'
1905: ,avalue => l_string);
1906: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1907: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1908: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1909: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1910: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);

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

1903: ,itemkey => l_item_key
1904: ,aname => 'APP_SUBJECT'
1905: ,avalue => l_string);
1906: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1907: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1908: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1909: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1910: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1911: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);

Line 1908: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);

1904: ,aname => 'APP_SUBJECT'
1905: ,avalue => l_string);
1906: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1907: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1908: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1909: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1910: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1911: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1912: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);

Line 1909: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);

1905: ,avalue => l_string);
1906: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1907: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1908: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1909: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1910: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1911: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1912: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1913: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);

Line 1910: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);

1906: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1907: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1908: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1909: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1910: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1911: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1912: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1913: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1914: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);

Line 1911: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);

1907: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1908: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1909: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1910: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1911: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1912: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1913: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1914: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1915: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);

Line 1912: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);

1908: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1909: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1910: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1911: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1912: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1913: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1914: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1915: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1916: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);

Line 1913: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);

1909: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1910: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1911: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1912: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1913: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1914: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1915: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1916: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1917: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

Line 1914: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);

1910: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1911: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1912: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1913: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1914: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1915: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1916: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1917: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1918: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);

Line 1915: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);

1911: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1912: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1913: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1914: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1915: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1916: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1917: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1918: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1919: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);

Line 1916: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);

1912: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1913: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1914: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1915: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1916: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1917: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1918: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1919: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1920: l_reason_meaning :=

Line 1917: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

1913: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1914: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1915: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1916: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1917: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1918: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1919: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1920: l_reason_meaning :=
1921: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);

Line 1918: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);

1914: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1915: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1916: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1917: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1918: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1919: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1920: l_reason_meaning :=
1921: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1922: fnd_message.set_token('REASON', l_reason_meaning, FALSE);

Line 1919: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);

1915: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1916: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1917: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1918: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1919: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1920: l_reason_meaning :=
1921: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1922: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1923: l_string1 := fnd_message.get;

Line 1922: fnd_message.set_token('REASON', l_reason_meaning, FALSE);

1918: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1919: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1920: l_reason_meaning :=
1921: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1922: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1923: l_string1 := fnd_message.get;
1924: /*
1925: l_note := wf_engine.getitemattrtext(
1926: itemtype => l_item_type

Line 1923: l_string1 := fnd_message.get;

1919: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1920: l_reason_meaning :=
1921: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1922: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1923: l_string1 := fnd_message.get;
1924: /*
1925: l_note := wf_engine.getitemattrtext(
1926: itemtype => l_item_type
1927: ,itemkey => l_item_key

Line 2070: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');

2066: ,aname => 'AMS_APPROVER');
2067: OPEN c_act_budget_rec(l_act_budget_id);
2068: FETCH c_act_budget_rec INTO l_request_rec;
2069: CLOSE c_act_budget_rec;
2070: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
2071: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2072: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2073: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
2074: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);

Line 2071: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);

2067: OPEN c_act_budget_rec(l_act_budget_id);
2068: FETCH c_act_budget_rec INTO l_request_rec;
2069: CLOSE c_act_budget_rec;
2070: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
2071: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2072: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2073: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
2074: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2075: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

Line 2072: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

2068: FETCH c_act_budget_rec INTO l_request_rec;
2069: CLOSE c_act_budget_rec;
2070: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
2071: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2072: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2073: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
2074: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2075: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2076: l_string := fnd_message.get;

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

2069: CLOSE c_act_budget_rec;
2070: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
2071: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2072: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2073: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
2074: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2075: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2076: l_string := fnd_message.get;
2077: wf_engine.setitemattrtext(

Line 2074: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);

2070: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
2071: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2072: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2073: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
2074: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2075: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2076: l_string := fnd_message.get;
2077: wf_engine.setitemattrtext(
2078: itemtype => l_item_type

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

2071: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2072: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2073: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
2074: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2075: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2076: l_string := fnd_message.get;
2077: wf_engine.setitemattrtext(
2078: itemtype => l_item_type
2079: ,itemkey => l_item_key

Line 2076: l_string := fnd_message.get;

2072: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2073: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
2074: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2075: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2076: l_string := fnd_message.get;
2077: wf_engine.setitemattrtext(
2078: itemtype => l_item_type
2079: ,itemkey => l_item_key
2080: ,aname => 'FYI_SUBJECT'

Line 2082: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');

2078: itemtype => l_item_type
2079: ,itemkey => l_item_key
2080: ,aname => 'FYI_SUBJECT'
2081: ,avalue => l_string);
2082: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
2083: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
2084: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2085: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
2086: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);

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

2079: ,itemkey => l_item_key
2080: ,aname => 'FYI_SUBJECT'
2081: ,avalue => l_string);
2082: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
2083: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
2084: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2085: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
2086: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
2087: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);

Line 2084: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);

2080: ,aname => 'FYI_SUBJECT'
2081: ,avalue => l_string);
2082: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
2083: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
2084: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2085: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
2086: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
2087: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
2088: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);

Line 2085: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);

2081: ,avalue => l_string);
2082: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
2083: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
2084: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2085: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
2086: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
2087: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
2088: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
2089: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);

Line 2086: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);

2082: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
2083: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
2084: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2085: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
2086: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
2087: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
2088: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
2089: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2090: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);

Line 2087: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);

2083: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
2084: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2085: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
2086: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
2087: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
2088: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
2089: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2090: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
2091: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);

Line 2088: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);

2084: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2085: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
2086: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
2087: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
2088: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
2089: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2090: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
2091: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
2092: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);

Line 2089: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);

2085: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
2086: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
2087: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
2088: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
2089: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2090: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
2091: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
2092: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
2093: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

Line 2090: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);

2086: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
2087: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
2088: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
2089: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2090: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
2091: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
2092: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
2093: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2094: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);

Line 2091: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);

2087: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
2088: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
2089: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2090: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
2091: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
2092: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
2093: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2094: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
2095: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);

Line 2092: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);

2088: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
2089: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2090: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
2091: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
2092: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
2093: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2094: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
2095: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
2096: l_reason_meaning :=

Line 2093: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

2089: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2090: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
2091: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
2092: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
2093: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2094: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
2095: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
2096: l_reason_meaning :=
2097: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);

Line 2094: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);

2090: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
2091: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
2092: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
2093: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2094: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
2095: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
2096: l_reason_meaning :=
2097: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
2098: fnd_message.set_token('REASON', l_reason_meaning, FALSE);

Line 2095: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);

2091: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
2092: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
2093: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2094: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
2095: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
2096: l_reason_meaning :=
2097: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
2098: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
2099: l_string1 := fnd_message.get;

Line 2098: fnd_message.set_token('REASON', l_reason_meaning, FALSE);

2094: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
2095: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
2096: l_reason_meaning :=
2097: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
2098: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
2099: l_string1 := fnd_message.get;
2100: /*
2101: l_note := wf_engine.getitemattrtext(
2102: itemtype => l_item_type

Line 2099: l_string1 := fnd_message.get;

2095: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
2096: l_reason_meaning :=
2097: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
2098: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
2099: l_string1 := fnd_message.get;
2100: /*
2101: l_note := wf_engine.getitemattrtext(
2102: itemtype => l_item_type
2103: ,itemkey => l_item_key

Line 2286: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

2282: IF (c_act_budget_rec%NOTFOUND) THEN
2283: CLOSE c_act_budget_rec;
2284:
2285: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2286: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2287: fnd_msg_pub.add;
2288: END IF;
2289:
2290: RAISE fnd_api.g_exc_error;

Line 2308: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

2304: IF (c_fund_rec%NOTFOUND) THEN
2305: CLOSE c_fund_rec;
2306:
2307: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2308: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2309: fnd_msg_pub.add;
2310: END IF;
2311:
2312: RAISE fnd_api.g_exc_error;

Line 2330: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

2326: IF (c_transfer_rec%NOTFOUND) THEN
2327: CLOSE c_fund_rec;
2328:
2329: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2330: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2331: fnd_msg_pub.add;
2332: END IF;
2333:
2334: RAISE fnd_api.g_exc_error;

Line 2348: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

2344: IF (c_budget_src_rec%NOTFOUND) THEN
2345: CLOSE c_budget_src_rec;
2346:
2347: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2348: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2349: fnd_msg_pub.add;
2350: END IF;
2351:
2352: RAISE fnd_api.g_exc_error;

Line 2407: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_FYI_SUB');

2403: ,itemkey => itemkey
2404: ,aname => 'AMS_APPROVER');
2405: */
2406:
2407: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_FYI_SUB');
2408: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2409: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2410: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2411: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);

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

2404: ,aname => 'AMS_APPROVER');
2405: */
2406:
2407: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_FYI_SUB');
2408: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2409: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2410: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2411: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2412: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

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

2405: */
2406:
2407: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_FYI_SUB');
2408: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2409: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2410: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2411: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2412: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2413: l_string := fnd_message.get;

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

2406:
2407: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_FYI_SUB');
2408: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2409: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2410: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2411: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2412: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2413: l_string := fnd_message.get;
2414: wf_engine.setitemattrtext(

Line 2411: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);

2407: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_FYI_SUB');
2408: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2409: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2410: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2411: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2412: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2413: l_string := fnd_message.get;
2414: wf_engine.setitemattrtext(
2415: itemtype => itemtype

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

2408: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2409: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2410: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2411: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2412: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2413: l_string := fnd_message.get;
2414: wf_engine.setitemattrtext(
2415: itemtype => itemtype
2416: ,itemkey => itemkey

Line 2413: l_string := fnd_message.get;

2409: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2410: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2411: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2412: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2413: l_string := fnd_message.get;
2414: wf_engine.setitemattrtext(
2415: itemtype => itemtype
2416: ,itemkey => itemkey
2417: ,aname => 'FYI_SUBJECT'

Line 2421: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_APP_SUB');

2417: ,aname => 'FYI_SUBJECT'
2418: ,avalue => l_string);
2419:
2420: -- set the approval subject
2421: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_APP_SUB');
2422: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2423: -- fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2424: -- fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2425: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);

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

2418: ,avalue => l_string);
2419:
2420: -- set the approval subject
2421: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_APP_SUB');
2422: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2423: -- fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2424: -- fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2425: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2426: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

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

2419:
2420: -- set the approval subject
2421: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_APP_SUB');
2422: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2423: -- fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2424: -- fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2425: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2426: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2427: l_string := fnd_message.get;

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

2420: -- set the approval subject
2421: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_APP_SUB');
2422: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2423: -- fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2424: -- fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2425: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2426: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2427: l_string := fnd_message.get;
2428: wf_engine.setitemattrtext(

Line 2425: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);

2421: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_APP_SUB');
2422: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2423: -- fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2424: -- fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2425: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2426: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2427: l_string := fnd_message.get;
2428: wf_engine.setitemattrtext(
2429: itemtype => itemtype

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

2422: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2423: -- fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2424: -- fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2425: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2426: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2427: l_string := fnd_message.get;
2428: wf_engine.setitemattrtext(
2429: itemtype => itemtype
2430: ,itemkey => itemkey

Line 2427: l_string := fnd_message.get;

2423: -- fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2424: -- fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2425: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2426: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2427: l_string := fnd_message.get;
2428: wf_engine.setitemattrtext(
2429: itemtype => itemtype
2430: ,itemkey => itemkey
2431: ,aname => 'APRV_SUBJECT'

Line 2434: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');

2430: ,itemkey => itemkey
2431: ,aname => 'APRV_SUBJECT'
2432: ,avalue => l_string);
2433: -- set the reject subject
2434: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');
2435: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2436: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2437: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2438: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);

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

2431: ,aname => 'APRV_SUBJECT'
2432: ,avalue => l_string);
2433: -- set the reject subject
2434: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');
2435: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2436: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2437: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2438: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2439: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

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

2432: ,avalue => l_string);
2433: -- set the reject subject
2434: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');
2435: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2436: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2437: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2438: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2439: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2440: l_string := fnd_message.get;

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

2433: -- set the reject subject
2434: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');
2435: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2436: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2437: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2438: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2439: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2440: l_string := fnd_message.get;
2441: wf_engine.setitemattrtext(

Line 2438: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);

2434: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');
2435: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2436: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2437: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2438: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2439: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2440: l_string := fnd_message.get;
2441: wf_engine.setitemattrtext(
2442: itemtype => itemtype

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

2435: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2436: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2437: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2438: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2439: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2440: l_string := fnd_message.get;
2441: wf_engine.setitemattrtext(
2442: itemtype => itemtype
2443: ,itemkey => itemkey

Line 2440: l_string := fnd_message.get;

2436: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2437: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2438: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2439: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2440: l_string := fnd_message.get;
2441: wf_engine.setitemattrtext(
2442: itemtype => itemtype
2443: ,itemkey => itemkey
2444: ,aname => 'REJECT_SUBJECT'

Line 2447: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');

2443: ,itemkey => itemkey
2444: ,aname => 'REJECT_SUBJECT'
2445: ,avalue => l_string);
2446: -- set the approval requred subject
2447: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
2448: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2449: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2450: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2451: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);

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

2444: ,aname => 'REJECT_SUBJECT'
2445: ,avalue => l_string);
2446: -- set the approval requred subject
2447: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
2448: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2449: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2450: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2451: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2452: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

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

2445: ,avalue => l_string);
2446: -- set the approval requred subject
2447: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
2448: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2449: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2450: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2451: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2452: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2453: l_string := fnd_message.get;

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

2446: -- set the approval requred subject
2447: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
2448: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2449: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2450: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2451: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2452: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2453: l_string := fnd_message.get;
2454: wf_engine.setitemattrtext(

Line 2451: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);

2447: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
2448: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2449: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2450: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2451: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2452: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2453: l_string := fnd_message.get;
2454: wf_engine.setitemattrtext(
2455: itemtype => itemtype

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

2448: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2449: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2450: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2451: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2452: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2453: l_string := fnd_message.get;
2454: wf_engine.setitemattrtext(
2455: itemtype => itemtype
2456: ,itemkey => itemkey

Line 2453: l_string := fnd_message.get;

2449: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2450: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2451: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2452: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2453: l_string := fnd_message.get;
2454: wf_engine.setitemattrtext(
2455: itemtype => itemtype
2456: ,itemkey => itemkey
2457: ,aname => 'APP_SUBJECT'

Line 2834: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

2830: IF (c_act_budget_rec%NOTFOUND) THEN
2831: CLOSE c_act_budget_rec;
2832:
2833: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2834: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2835: fnd_msg_pub.add;
2836: END IF;
2837:
2838: RAISE fnd_api.g_exc_error;

Line 3075: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

3071: IF (c_fund_detail%NOTFOUND) THEN
3072: CLOSE c_fund_detail;
3073:
3074: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3075: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
3076: fnd_msg_pub.add;
3077: END IF;
3078:
3079: RAISE fnd_api.g_exc_error;

Line 3090: fnd_message.set_name('OZF', 'OZF_AMT_UNAVAILABLE');

3086:
3087: IF p_transfer_type = 'RESERVE' THEN
3088: IF NVL(l_available_amt, 0) < NVL(p_requested_amount, 0) THEN
3089: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3090: fnd_message.set_name('OZF', 'OZF_AMT_UNAVAILABLE');
3091: fnd_msg_pub.add;
3092: END IF;
3093:
3094: RAISE fnd_api.g_exc_error;

Line 3101: fnd_message.set_name('OZF', 'OZF_AMT_UNAVAILABLE');

3097: l_fund_rec.holdback_amt := NVL(l_holdback_amt, 0) + NVL(p_requested_amount, 0); -- HOLDBACK AMT
3098: ELSIF p_transfer_type = 'RELEASE' THEN
3099: IF NVL(l_holdback_amt, 0) < NVL(p_requested_amount, 0) THEN
3100: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3101: fnd_message.set_name('OZF', 'OZF_AMT_UNAVAILABLE');
3102: fnd_msg_pub.add;
3103: END IF;
3104:
3105: RAISE fnd_api.g_exc_error;