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 175: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1019: IF (c_parent_fund_owner%NOTFOUND) THEN
1020: CLOSE c_parent_fund_owner;
1021:
1022: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1023: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1024: fnd_msg_pub.add;
1025: END IF;
1026:
1027: RAISE fnd_api.g_exc_error;

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

1048: IF (c_fm_fund_currency%NOTFOUND) THEN
1049: CLOSE c_fm_fund_currency;
1050:
1051: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1052: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1053: fnd_msg_pub.add;
1054: END IF;
1055:
1056: RAISE fnd_api.g_exc_error;

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

1063: IF (c_to_fund_currency%NOTFOUND) THEN
1064: CLOSE c_to_fund_currency;
1065:
1066: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1067: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1068: fnd_msg_pub.add;
1069: END IF;
1070:
1071: RAISE fnd_api.g_exc_error;

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

1099: IF (c_act_budget_rec%NOTFOUND) THEN
1100: CLOSE c_act_budget_rec;
1101:
1102: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1103: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1104: fnd_msg_pub.add;
1105: END IF;
1106:
1107: RAISE fnd_api.g_exc_error;

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

1342: ,aname => 'AMS_APPROVER_DISPLAY_NAME');
1343: OPEN c_act_budget_rec(l_act_budget_id);
1344: FETCH c_act_budget_rec INTO l_request_rec;
1345: CLOSE c_act_budget_rec;
1346: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_FYI_SUB');
1347: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1348: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1349: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1350: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);

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

1343: OPEN c_act_budget_rec(l_act_budget_id);
1344: FETCH c_act_budget_rec INTO l_request_rec;
1345: CLOSE c_act_budget_rec;
1346: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_FYI_SUB');
1347: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1348: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1349: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1350: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1351: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

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

1344: FETCH c_act_budget_rec INTO l_request_rec;
1345: CLOSE c_act_budget_rec;
1346: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_FYI_SUB');
1347: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1348: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1349: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1350: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1351: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1352: l_string := fnd_message.get;

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

1345: CLOSE c_act_budget_rec;
1346: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_FYI_SUB');
1347: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1348: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1349: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1350: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1351: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1352: l_string := fnd_message.get;
1353: wf_engine.setitemattrtext(

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

1346: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_FYI_SUB');
1347: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1348: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1349: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1350: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1351: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1352: l_string := fnd_message.get;
1353: wf_engine.setitemattrtext(
1354: itemtype => l_item_type

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

1347: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1348: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1349: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1350: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1351: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1352: l_string := fnd_message.get;
1353: wf_engine.setitemattrtext(
1354: itemtype => l_item_type
1355: ,itemkey => l_item_key

Line 1352: l_string := fnd_message.get;

1348: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1349: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1350: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1351: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1352: l_string := fnd_message.get;
1353: wf_engine.setitemattrtext(
1354: itemtype => l_item_type
1355: ,itemkey => l_item_key
1356: ,aname => 'FYI_SUBJECT'

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

1354: itemtype => l_item_type
1355: ,itemkey => l_item_key
1356: ,aname => 'FYI_SUBJECT'
1357: ,avalue => l_string);
1358: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1359: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1360: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1361: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1362: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);

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

1355: ,itemkey => l_item_key
1356: ,aname => 'FYI_SUBJECT'
1357: ,avalue => l_string);
1358: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1359: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1360: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1361: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1362: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1363: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);

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

1356: ,aname => 'FYI_SUBJECT'
1357: ,avalue => l_string);
1358: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1359: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1360: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1361: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1362: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1363: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1364: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);

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

1357: ,avalue => l_string);
1358: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1359: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1360: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1361: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1362: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1363: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1364: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1365: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);

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

1358: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1359: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1360: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1361: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1362: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1363: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1364: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1365: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1366: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);

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

1359: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1360: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1361: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1362: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1363: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1364: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1365: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1366: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1367: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);

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

1360: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1361: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1362: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1363: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1364: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1365: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1366: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1367: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1368: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);

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

1361: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1362: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1363: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1364: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1365: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1366: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1367: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1368: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1369: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

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

1362: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1363: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1364: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1365: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1366: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1367: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1368: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1369: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1370: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);

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

1363: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1364: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1365: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1366: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1367: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1368: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1369: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1370: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1371: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);

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

1364: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1365: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1366: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1367: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1368: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1369: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1370: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1371: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1372: l_reason_meaning :=

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

1365: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1366: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1367: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1368: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1369: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1370: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1371: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1372: l_reason_meaning :=
1373: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);

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

1366: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1367: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1368: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1369: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1370: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1371: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1372: l_reason_meaning :=
1373: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1374: fnd_message.set_token('REASON', l_reason_meaning, FALSE);

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

1367: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1368: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1369: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1370: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1371: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1372: l_reason_meaning :=
1373: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1374: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1375: l_string1 := fnd_message.get;

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

1370: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1371: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1372: l_reason_meaning :=
1373: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1374: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1375: l_string1 := fnd_message.get;
1376:
1377: l_note := wf_engine.getitemattrtext(
1378: itemtype => l_item_type

Line 1375: l_string1 := fnd_message.get;

1371: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1372: l_reason_meaning :=
1373: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1374: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1375: l_string1 := fnd_message.get;
1376:
1377: l_note := wf_engine.getitemattrtext(
1378: itemtype => l_item_type
1379: ,itemkey => l_item_key

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

1534:
1535: OPEN c_act_budget_rec(l_act_budget_id);
1536: FETCH c_act_budget_rec INTO l_request_rec;
1537: CLOSE c_act_budget_rec;
1538: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_APP_SUB');
1539: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1540: -- fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1541: -- fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1542: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);

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

1535: OPEN c_act_budget_rec(l_act_budget_id);
1536: FETCH c_act_budget_rec INTO l_request_rec;
1537: CLOSE c_act_budget_rec;
1538: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_APP_SUB');
1539: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1540: -- fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1541: -- fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1542: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1543: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

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

1536: FETCH c_act_budget_rec INTO l_request_rec;
1537: CLOSE c_act_budget_rec;
1538: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_APP_SUB');
1539: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1540: -- fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1541: -- fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1542: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1543: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1544: l_string := fnd_message.get;

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

1537: CLOSE c_act_budget_rec;
1538: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_APP_SUB');
1539: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1540: -- fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1541: -- fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1542: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1543: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1544: l_string := fnd_message.get;
1545: wf_engine.setitemattrtext(

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

1538: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_APP_SUB');
1539: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1540: -- fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1541: -- fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1542: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1543: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1544: l_string := fnd_message.get;
1545: wf_engine.setitemattrtext(
1546: itemtype => l_item_type

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

1539: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1540: -- fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1541: -- fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1542: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1543: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1544: l_string := fnd_message.get;
1545: wf_engine.setitemattrtext(
1546: itemtype => l_item_type
1547: ,itemkey => l_item_key

Line 1544: l_string := fnd_message.get;

1540: -- fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1541: -- fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1542: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1543: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1544: l_string := fnd_message.get;
1545: wf_engine.setitemattrtext(
1546: itemtype => l_item_type
1547: ,itemkey => l_item_key
1548: ,aname => 'APRV_SUBJECT'

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

1546: itemtype => l_item_type
1547: ,itemkey => l_item_key
1548: ,aname => 'APRV_SUBJECT'
1549: ,avalue => l_string);
1550: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1551: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1552: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1553: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1554: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);

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

1547: ,itemkey => l_item_key
1548: ,aname => 'APRV_SUBJECT'
1549: ,avalue => l_string);
1550: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1551: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1552: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1553: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1554: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1555: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);

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

1548: ,aname => 'APRV_SUBJECT'
1549: ,avalue => l_string);
1550: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1551: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1552: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1553: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1554: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1555: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1556: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);

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

1549: ,avalue => l_string);
1550: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1551: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1552: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1553: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1554: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1555: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1556: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1557: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);

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

1550: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1551: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1552: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1553: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1554: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1555: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1556: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1557: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1558: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);

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

1551: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1552: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1553: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1554: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1555: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1556: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1557: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1558: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1559: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);

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

1552: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1553: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1554: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1555: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1556: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1557: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1558: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1559: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1560: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);

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

1553: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1554: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1555: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1556: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1557: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1558: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1559: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1560: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1561: -- commented on 10/22/2001 mpande

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

1554: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1555: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1556: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1557: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1558: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1559: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1560: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1561: -- commented on 10/22/2001 mpande
1562: -- yzhao: 01/23/2003 uncomment following 2 lines as tokens are defined in message

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

1555: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1556: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1557: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1558: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1559: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1560: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1561: -- commented on 10/22/2001 mpande
1562: -- yzhao: 01/23/2003 uncomment following 2 lines as tokens are defined in message
1563: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

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

1556: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1557: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1558: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1559: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1560: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1561: -- commented on 10/22/2001 mpande
1562: -- yzhao: 01/23/2003 uncomment following 2 lines as tokens are defined in message
1563: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1564: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);

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

1559: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1560: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1561: -- commented on 10/22/2001 mpande
1562: -- yzhao: 01/23/2003 uncomment following 2 lines as tokens are defined in message
1563: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1564: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1565: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1566: l_reason_meaning :=
1567: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);

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

1560: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1561: -- commented on 10/22/2001 mpande
1562: -- yzhao: 01/23/2003 uncomment following 2 lines as tokens are defined in message
1563: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1564: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1565: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1566: l_reason_meaning :=
1567: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1568: fnd_message.set_token('REASON', l_reason_meaning, FALSE);

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

1561: -- commented on 10/22/2001 mpande
1562: -- yzhao: 01/23/2003 uncomment following 2 lines as tokens are defined in message
1563: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1564: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1565: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1566: l_reason_meaning :=
1567: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1568: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1569: l_string1 := fnd_message.get;

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

1564: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1565: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1566: l_reason_meaning :=
1567: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1568: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1569: l_string1 := fnd_message.get;
1570: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_ADDENDUM');
1571: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1572: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

Line 1569: l_string1 := fnd_message.get;

1565: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1566: l_reason_meaning :=
1567: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1568: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1569: l_string1 := fnd_message.get;
1570: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_ADDENDUM');
1571: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1572: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1573: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);

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

1566: l_reason_meaning :=
1567: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1568: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1569: l_string1 := fnd_message.get;
1570: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_ADDENDUM');
1571: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1572: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1573: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1574: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL

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

1567: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1568: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1569: l_string1 := fnd_message.get;
1570: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_ADDENDUM');
1571: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1572: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1573: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1574: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL
1575: fnd_message.set_token('NOTES_FROM_APPROVER', l_note, FALSE); */

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

1568: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1569: l_string1 := fnd_message.get;
1570: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_ADDENDUM');
1571: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1572: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1573: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1574: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL
1575: fnd_message.set_token('NOTES_FROM_APPROVER', l_note, FALSE); */
1576: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);

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

1569: l_string1 := fnd_message.get;
1570: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_ADDENDUM');
1571: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1572: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1573: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1574: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL
1575: fnd_message.set_token('NOTES_FROM_APPROVER', l_note, FALSE); */
1576: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);
1577: l_string2 := fnd_message.get;

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

1571: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1572: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1573: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1574: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL
1575: fnd_message.set_token('NOTES_FROM_APPROVER', l_note, FALSE); */
1576: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);
1577: l_string2 := fnd_message.get;
1578: /*
1579: l_note := wf_engine.getitemattrtext(

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

1572: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1573: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1574: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL
1575: fnd_message.set_token('NOTES_FROM_APPROVER', l_note, FALSE); */
1576: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);
1577: l_string2 := fnd_message.get;
1578: /*
1579: l_note := wf_engine.getitemattrtext(
1580: itemtype => l_item_type

Line 1577: l_string2 := fnd_message.get;

1573: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
1574: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL
1575: fnd_message.set_token('NOTES_FROM_APPROVER', l_note, FALSE); */
1576: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);
1577: l_string2 := fnd_message.get;
1578: /*
1579: l_note := wf_engine.getitemattrtext(
1580: itemtype => l_item_type
1581: ,itemkey => l_item_key

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

1721: ,aname => 'AMS_APPROVER');
1722: OPEN c_act_budget_rec(l_act_budget_id);
1723: FETCH c_act_budget_rec INTO l_request_rec;
1724: CLOSE c_act_budget_rec;
1725: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');
1726: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1727: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1728: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1729: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);

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

1722: OPEN c_act_budget_rec(l_act_budget_id);
1723: FETCH c_act_budget_rec INTO l_request_rec;
1724: CLOSE c_act_budget_rec;
1725: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');
1726: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1727: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1728: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1729: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1730: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

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

1723: FETCH c_act_budget_rec INTO l_request_rec;
1724: CLOSE c_act_budget_rec;
1725: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');
1726: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1727: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1728: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1729: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1730: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1731: l_string := fnd_message.get;

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

1724: CLOSE c_act_budget_rec;
1725: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');
1726: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1727: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1728: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1729: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1730: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1731: l_string := fnd_message.get;
1732: wf_engine.setitemattrtext(

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

1725: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');
1726: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1727: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1728: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1729: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1730: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1731: l_string := fnd_message.get;
1732: wf_engine.setitemattrtext(
1733: itemtype => l_item_type

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

1726: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1727: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1728: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1729: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1730: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1731: l_string := fnd_message.get;
1732: wf_engine.setitemattrtext(
1733: itemtype => l_item_type
1734: ,itemkey => l_item_key

Line 1731: l_string := fnd_message.get;

1727: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1728: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1729: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1730: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1731: l_string := fnd_message.get;
1732: wf_engine.setitemattrtext(
1733: itemtype => l_item_type
1734: ,itemkey => l_item_key
1735: ,aname => 'REJECT_SUBJECT'

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

1733: itemtype => l_item_type
1734: ,itemkey => l_item_key
1735: ,aname => 'REJECT_SUBJECT'
1736: ,avalue => l_string);
1737: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1738: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1739: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1740: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1741: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);

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

1734: ,itemkey => l_item_key
1735: ,aname => 'REJECT_SUBJECT'
1736: ,avalue => l_string);
1737: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1738: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1739: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1740: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1741: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1742: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);

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

1735: ,aname => 'REJECT_SUBJECT'
1736: ,avalue => l_string);
1737: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1738: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1739: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1740: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1741: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1742: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1743: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);

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

1736: ,avalue => l_string);
1737: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1738: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1739: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1740: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1741: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1742: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1743: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1744: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);

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

1737: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1738: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1739: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1740: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1741: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1742: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1743: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1744: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1745: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);

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

1738: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1739: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1740: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1741: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1742: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1743: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1744: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1745: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1746: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);

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

1739: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1740: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1741: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1742: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1743: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1744: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1745: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1746: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1747: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);

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

1740: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1741: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1742: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1743: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1744: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1745: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1746: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1747: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1748: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

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

1741: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1742: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1743: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1744: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1745: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1746: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1747: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1748: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1749: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);

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

1742: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1743: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1744: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1745: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1746: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1747: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1748: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1749: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1750: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);

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

1743: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1744: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1745: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1746: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1747: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1748: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1749: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1750: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1751: l_reason_meaning :=

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

1744: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1745: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1746: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1747: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1748: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1749: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1750: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1751: l_reason_meaning :=
1752: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);

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

1745: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1746: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1747: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1748: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1749: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1750: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1751: l_reason_meaning :=
1752: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1753: fnd_message.set_token('REASON', l_reason_meaning, FALSE);

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

1746: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1747: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1748: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1749: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1750: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1751: l_reason_meaning :=
1752: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1753: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1754: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);

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

1749: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1750: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1751: l_reason_meaning :=
1752: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1753: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1754: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1755: l_string1 := fnd_message.get;
1756: /*
1757: l_note := wf_engine.getitemattrtext(

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

1750: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1751: l_reason_meaning :=
1752: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1753: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1754: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1755: l_string1 := fnd_message.get;
1756: /*
1757: l_note := wf_engine.getitemattrtext(
1758: itemtype => l_item_type

Line 1755: l_string1 := fnd_message.get;

1751: l_reason_meaning :=
1752: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1753: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1754: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1755: l_string1 := fnd_message.get;
1756: /*
1757: l_note := wf_engine.getitemattrtext(
1758: itemtype => l_item_type
1759: ,itemkey => l_item_key

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

1773: itemtype=> l_item_type,
1774: itemkey=> l_item_key,
1775: aname => 'APPROVAL_NOTE'
1776: );
1777: fnd_message.set_name ('OZF', 'OZF_WF_NTF_APPROVER_NOTE');
1778: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);
1779: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);
1780: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVer's NOTE NOT SHOWING IN rejection EMAIL */
1781:

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

1774: itemkey=> l_item_key,
1775: aname => 'APPROVAL_NOTE'
1776: );
1777: fnd_message.set_name ('OZF', 'OZF_WF_NTF_APPROVER_NOTE');
1778: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);
1779: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);
1780: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVer's NOTE NOT SHOWING IN rejection EMAIL */
1781:
1782: -- IF (display_type = 'text/plain') THEN

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

1775: aname => 'APPROVAL_NOTE'
1776: );
1777: fnd_message.set_name ('OZF', 'OZF_WF_NTF_APPROVER_NOTE');
1778: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);
1779: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);
1780: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVer's NOTE NOT SHOWING IN rejection EMAIL */
1781:
1782: -- IF (display_type = 'text/plain') THEN
1783: l_rej_notification :=

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

1911: ,aname => 'AMS_APPROVER_DISPLAY_NAME');
1912: OPEN c_act_budget_rec(l_act_budget_id);
1913: FETCH c_act_budget_rec INTO l_request_rec;
1914: CLOSE c_act_budget_rec;
1915: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
1916: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1917: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1918: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1919: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);

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

1912: OPEN c_act_budget_rec(l_act_budget_id);
1913: FETCH c_act_budget_rec INTO l_request_rec;
1914: CLOSE c_act_budget_rec;
1915: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
1916: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1917: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1918: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1919: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1920: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

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

1913: FETCH c_act_budget_rec INTO l_request_rec;
1914: CLOSE c_act_budget_rec;
1915: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
1916: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1917: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1918: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1919: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1920: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1921: l_string := fnd_message.get;

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

1914: CLOSE c_act_budget_rec;
1915: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
1916: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1917: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1918: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1919: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1920: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1921: l_string := fnd_message.get;
1922: wf_engine.setitemattrtext(

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

1915: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
1916: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1917: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1918: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1919: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1920: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1921: l_string := fnd_message.get;
1922: wf_engine.setitemattrtext(
1923: itemtype => l_item_type

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

1916: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1917: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1918: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1919: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1920: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1921: l_string := fnd_message.get;
1922: wf_engine.setitemattrtext(
1923: itemtype => l_item_type
1924: ,itemkey => l_item_key

Line 1921: l_string := fnd_message.get;

1917: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1918: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
1919: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1920: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1921: l_string := fnd_message.get;
1922: wf_engine.setitemattrtext(
1923: itemtype => l_item_type
1924: ,itemkey => l_item_key
1925: ,aname => 'APP_SUBJECT'

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

1923: itemtype => l_item_type
1924: ,itemkey => l_item_key
1925: ,aname => 'APP_SUBJECT'
1926: ,avalue => l_string);
1927: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1928: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1929: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1930: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1931: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);

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

1924: ,itemkey => l_item_key
1925: ,aname => 'APP_SUBJECT'
1926: ,avalue => l_string);
1927: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1928: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1929: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1930: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1931: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1932: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);

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

1925: ,aname => 'APP_SUBJECT'
1926: ,avalue => l_string);
1927: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1928: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1929: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1930: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1931: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1932: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1933: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);

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

1926: ,avalue => l_string);
1927: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1928: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1929: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1930: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1931: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1932: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1933: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1934: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);

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

1927: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
1928: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1929: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1930: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1931: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1932: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1933: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1934: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1935: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);

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

1928: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
1929: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1930: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1931: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1932: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1933: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1934: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1935: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1936: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);

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

1929: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
1930: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1931: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1932: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1933: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1934: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1935: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1936: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1937: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);

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

1930: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
1931: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1932: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1933: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1934: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1935: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1936: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1937: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1938: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

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

1931: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
1932: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1933: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1934: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1935: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1936: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1937: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1938: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1939: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);

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

1932: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
1933: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1934: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1935: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1936: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1937: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1938: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1939: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1940: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);

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

1933: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
1934: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1935: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1936: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1937: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1938: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1939: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1940: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1941: l_reason_meaning :=

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

1934: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
1935: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1936: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1937: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1938: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1939: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1940: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1941: l_reason_meaning :=
1942: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);

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

1935: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
1936: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1937: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1938: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1939: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1940: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1941: l_reason_meaning :=
1942: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1943: fnd_message.set_token('REASON', l_reason_meaning, FALSE);

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

1936: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
1937: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
1938: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1939: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1940: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1941: l_reason_meaning :=
1942: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1943: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1944: l_string1 := fnd_message.get;

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

1939: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1940: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1941: l_reason_meaning :=
1942: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1943: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1944: l_string1 := fnd_message.get;
1945: /*
1946: l_note := wf_engine.getitemattrtext(
1947: itemtype => l_item_type

Line 1944: l_string1 := fnd_message.get;

1940: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1941: l_reason_meaning :=
1942: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1943: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1944: l_string1 := fnd_message.get;
1945: /*
1946: l_note := wf_engine.getitemattrtext(
1947: itemtype => l_item_type
1948: ,itemkey => l_item_key

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

2087: ,aname => 'AMS_APPROVER');
2088: OPEN c_act_budget_rec(l_act_budget_id);
2089: FETCH c_act_budget_rec INTO l_request_rec;
2090: CLOSE c_act_budget_rec;
2091: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
2092: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2093: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2094: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
2095: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);

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

2088: OPEN c_act_budget_rec(l_act_budget_id);
2089: FETCH c_act_budget_rec INTO l_request_rec;
2090: CLOSE c_act_budget_rec;
2091: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
2092: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2093: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2094: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
2095: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2096: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

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

2089: FETCH c_act_budget_rec INTO l_request_rec;
2090: CLOSE c_act_budget_rec;
2091: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
2092: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2093: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2094: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
2095: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2096: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2097: l_string := fnd_message.get;

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

2090: CLOSE c_act_budget_rec;
2091: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
2092: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2093: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2094: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
2095: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2096: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2097: l_string := fnd_message.get;
2098: wf_engine.setitemattrtext(

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

2091: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
2092: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2093: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2094: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
2095: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2096: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2097: l_string := fnd_message.get;
2098: wf_engine.setitemattrtext(
2099: itemtype => l_item_type

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

2092: fnd_message.set_token('BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2093: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2094: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
2095: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2096: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2097: l_string := fnd_message.get;
2098: wf_engine.setitemattrtext(
2099: itemtype => l_item_type
2100: ,itemkey => l_item_key

Line 2097: l_string := fnd_message.get;

2093: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2094: fnd_message.set_token('AMOUNT', l_requested_amt, FALSE);
2095: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2096: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2097: l_string := fnd_message.get;
2098: wf_engine.setitemattrtext(
2099: itemtype => l_item_type
2100: ,itemkey => l_item_key
2101: ,aname => 'FYI_SUBJECT'

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

2099: itemtype => l_item_type
2100: ,itemkey => l_item_key
2101: ,aname => 'FYI_SUBJECT'
2102: ,avalue => l_string);
2103: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
2104: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
2105: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2106: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
2107: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);

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

2100: ,itemkey => l_item_key
2101: ,aname => 'FYI_SUBJECT'
2102: ,avalue => l_string);
2103: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
2104: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
2105: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2106: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
2107: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
2108: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);

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

2101: ,aname => 'FYI_SUBJECT'
2102: ,avalue => l_string);
2103: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
2104: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
2105: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2106: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
2107: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
2108: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
2109: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);

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

2102: ,avalue => l_string);
2103: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
2104: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
2105: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2106: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
2107: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
2108: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
2109: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
2110: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);

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

2103: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUEST_INFO');
2104: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
2105: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2106: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
2107: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
2108: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
2109: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
2110: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2111: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);

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

2104: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
2105: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2106: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
2107: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
2108: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
2109: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
2110: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2111: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
2112: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);

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

2105: fnd_message.set_token('REQUEST_NUMBER', l_act_budget_id, FALSE);
2106: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
2107: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
2108: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
2109: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
2110: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2111: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
2112: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
2113: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);

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

2106: fnd_message.set_token('REQUEST_DATE', l_request_rec.request_date, FALSE);
2107: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
2108: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
2109: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
2110: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2111: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
2112: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
2113: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
2114: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);

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

2107: fnd_message.set_token('FROM_BUDGET_NAME', l_request_rec.from_budget_name, FALSE);
2108: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
2109: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
2110: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2111: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
2112: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
2113: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
2114: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2115: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);

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

2108: fnd_message.set_token('FROM_BUDGET_NUMBER', l_request_rec.from_budget_number, FALSE);
2109: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
2110: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2111: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
2112: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
2113: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
2114: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2115: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
2116: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);

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

2109: fnd_message.set_token('FROM_BUDGET_OWNER', l_request_rec.from_budget_owner_name, FALSE);
2110: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2111: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
2112: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
2113: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
2114: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2115: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
2116: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
2117: l_reason_meaning :=

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

2110: fnd_message.set_token('TO_BUDGET_NAME', l_request_rec.to_budget_name, FALSE);
2111: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
2112: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
2113: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
2114: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2115: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
2116: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
2117: l_reason_meaning :=
2118: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);

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

2111: fnd_message.set_token('To_BUDGET_NUMBER', l_request_rec.to_budget_number, FALSE);
2112: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
2113: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
2114: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2115: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
2116: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
2117: l_reason_meaning :=
2118: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
2119: fnd_message.set_token('REASON', l_reason_meaning, FALSE);

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

2112: fnd_message.set_token('TO_BUDGET_OWNER', l_request_rec.to_budget_owner_name, FALSE);
2113: fnd_message.set_token('REQUIRED_BY_DATE', l_request_rec.date_required_by, FALSE);
2114: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2115: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
2116: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
2117: l_reason_meaning :=
2118: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
2119: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
2120: l_string1 := fnd_message.get;

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

2115: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
2116: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
2117: l_reason_meaning :=
2118: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
2119: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
2120: l_string1 := fnd_message.get;
2121: /*
2122: l_note := wf_engine.getitemattrtext(
2123: itemtype => l_item_type

Line 2120: l_string1 := fnd_message.get;

2116: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
2117: l_reason_meaning :=
2118: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
2119: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
2120: l_string1 := fnd_message.get;
2121: /*
2122: l_note := wf_engine.getitemattrtext(
2123: itemtype => l_item_type
2124: ,itemkey => l_item_key

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

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

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

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

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

2347: IF (c_transfer_rec%NOTFOUND) THEN
2348: CLOSE c_fund_rec;
2349:
2350: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2351: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2352: fnd_msg_pub.add;
2353: END IF;
2354:
2355: RAISE fnd_api.g_exc_error;

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

2365: IF (c_budget_src_rec%NOTFOUND) THEN
2366: CLOSE c_budget_src_rec;
2367:
2368: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2369: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2370: fnd_msg_pub.add;
2371: END IF;
2372:
2373: RAISE fnd_api.g_exc_error;

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

2431: ,itemkey => itemkey
2432: ,aname => 'AMS_APPROVER');
2433: */
2434:
2435: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_FYI_SUB');
2436: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2437: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2438: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2439: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);

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

2432: ,aname => 'AMS_APPROVER');
2433: */
2434:
2435: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_FYI_SUB');
2436: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2437: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2438: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2439: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2440: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

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

2433: */
2434:
2435: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_FYI_SUB');
2436: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2437: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2438: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2439: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2440: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2441: l_string := fnd_message.get;

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

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

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

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

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

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

Line 2441: l_string := fnd_message.get;

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

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

2445: ,aname => 'FYI_SUBJECT'
2446: ,avalue => l_string);
2447:
2448: -- set the approval subject
2449: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_APP_SUB');
2450: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2451: -- fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2452: -- fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2453: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);

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

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

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

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

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

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

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

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

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

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

Line 2455: l_string := fnd_message.get;

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

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

2458: ,itemkey => itemkey
2459: ,aname => 'APRV_SUBJECT'
2460: ,avalue => l_string);
2461: -- set the reject subject
2462: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');
2463: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2464: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2465: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2466: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);

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

2459: ,aname => 'APRV_SUBJECT'
2460: ,avalue => l_string);
2461: -- set the reject subject
2462: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');
2463: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2464: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2465: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2466: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2467: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

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

2460: ,avalue => l_string);
2461: -- set the reject subject
2462: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');
2463: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2464: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2465: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2466: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2467: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2468: l_string := fnd_message.get;

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

2461: -- set the reject subject
2462: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');
2463: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2464: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2465: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2466: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2467: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2468: l_string := fnd_message.get;
2469: wf_engine.setitemattrtext(

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

2462: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_REJ_SUB');
2463: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2464: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2465: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2466: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2467: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2468: l_string := fnd_message.get;
2469: wf_engine.setitemattrtext(
2470: itemtype => itemtype

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

2463: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2464: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2465: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2466: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2467: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2468: l_string := fnd_message.get;
2469: wf_engine.setitemattrtext(
2470: itemtype => itemtype
2471: ,itemkey => itemkey

Line 2468: l_string := fnd_message.get;

2464: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2465: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2466: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2467: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2468: l_string := fnd_message.get;
2469: wf_engine.setitemattrtext(
2470: itemtype => itemtype
2471: ,itemkey => itemkey
2472: ,aname => 'REJECT_SUBJECT'

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

2471: ,itemkey => itemkey
2472: ,aname => 'REJECT_SUBJECT'
2473: ,avalue => l_string);
2474: -- set the approval requred subject
2475: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
2476: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2477: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2478: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2479: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);

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

2472: ,aname => 'REJECT_SUBJECT'
2473: ,avalue => l_string);
2474: -- set the approval requred subject
2475: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
2476: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2477: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2478: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2479: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2480: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

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

2473: ,avalue => l_string);
2474: -- set the approval requred subject
2475: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
2476: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2477: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2478: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2479: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2480: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2481: l_string := fnd_message.get;

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

2474: -- set the approval requred subject
2475: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
2476: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2477: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2478: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2479: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2480: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2481: l_string := fnd_message.get;
2482: wf_engine.setitemattrtext(

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

2475: fnd_message.set_name('OZF', 'OZF_WF_NTF_APPROVER_OF_REQ_SUB');
2476: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2477: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2478: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2479: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2480: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2481: l_string := fnd_message.get;
2482: wf_engine.setitemattrtext(
2483: itemtype => itemtype

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

2476: fnd_message.set_token('BUDGET_NAME', l_object_details.name, FALSE);
2477: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2478: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2479: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2480: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2481: l_string := fnd_message.get;
2482: wf_engine.setitemattrtext(
2483: itemtype => itemtype
2484: ,itemkey => itemkey

Line 2481: l_string := fnd_message.get;

2477: fnd_message.set_token('CURRENCY_CODE', l_object_details.currency, FALSE);
2478: fnd_message.set_token('AMOUNT', l_object_details.total_header_amount, FALSE);
2479: fnd_message.set_token('REQUEST_NUMBER', l_activity_id, FALSE);
2480: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
2481: l_string := fnd_message.get;
2482: wf_engine.setitemattrtext(
2483: itemtype => itemtype
2484: ,itemkey => itemkey
2485: ,aname => 'APP_SUBJECT'

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

2858: IF (c_act_budget_rec%NOTFOUND) THEN
2859: CLOSE c_act_budget_rec;
2860:
2861: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2862: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2863: fnd_msg_pub.add;
2864: END IF;
2865:
2866: RAISE fnd_api.g_exc_error;

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

3099: IF (c_fund_detail%NOTFOUND) THEN
3100: CLOSE c_fund_detail;
3101:
3102: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3103: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
3104: fnd_msg_pub.add;
3105: END IF;
3106:
3107: RAISE fnd_api.g_exc_error;

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

3114:
3115: IF p_transfer_type = 'RESERVE' THEN
3116: IF NVL(l_available_amt, 0) < NVL(p_requested_amount, 0) THEN
3117: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3118: fnd_message.set_name('OZF', 'OZF_AMT_UNAVAILABLE');
3119: fnd_msg_pub.add;
3120: END IF;
3121:
3122: RAISE fnd_api.g_exc_error;

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

3125: l_fund_rec.holdback_amt := NVL(l_holdback_amt, 0) + NVL(p_requested_amount, 0); -- HOLDBACK AMT
3126: ELSIF p_transfer_type = 'RELEASE' THEN
3127: IF NVL(l_holdback_amt, 0) < NVL(p_requested_amount, 0) THEN
3128: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3129: fnd_message.set_name('OZF', 'OZF_AMT_UNAVAILABLE');
3130: fnd_msg_pub.add;
3131: END IF;
3132:
3133: RAISE fnd_api.g_exc_error;