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

Line 152: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_FORWARD_SUBJ');

148: l_offer_adj_name ;
149: CLOSE c_offer_adj_info;
150:
151:
152: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_FORWARD_SUBJ');
153: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
154: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
155: l_string := SUBSTR(fnd_message.get,1,1000);
156:

Line 153: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);

149: CLOSE c_offer_adj_info;
150:
151:
152: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_FORWARD_SUBJ');
153: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
154: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
155: l_string := SUBSTR(fnd_message.get,1,1000);
156:
157: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_FORWARD_INFO');

Line 154: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);

150:
151:
152: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_FORWARD_SUBJ');
153: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
154: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
155: l_string := SUBSTR(fnd_message.get,1,1000);
156:
157: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_FORWARD_INFO');
158: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);

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

151:
152: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_FORWARD_SUBJ');
153: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
154: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
155: l_string := SUBSTR(fnd_message.get,1,1000);
156:
157: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_FORWARD_INFO');
158: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
159: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

Line 157: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_FORWARD_INFO');

153: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
154: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
155: l_string := SUBSTR(fnd_message.get,1,1000);
156:
157: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_FORWARD_INFO');
158: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
159: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
160: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
161: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);

Line 158: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);

154: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
155: l_string := SUBSTR(fnd_message.get,1,1000);
156:
157: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_FORWARD_INFO');
158: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
159: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
160: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
161: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
162: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);

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

155: l_string := SUBSTR(fnd_message.get,1,1000);
156:
157: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_FORWARD_INFO');
158: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
159: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
160: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
161: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
162: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
163: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);

Line 160: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);

156:
157: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_FORWARD_INFO');
158: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
159: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
160: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
161: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
162: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
163: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
164: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);

Line 161: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);

157: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_FORWARD_INFO');
158: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
159: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
160: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
161: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
162: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
163: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
164: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
165: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);

Line 162: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);

158: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
159: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
160: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
161: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
162: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
163: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
164: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
165: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
166: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);

Line 163: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);

159: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
160: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
161: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
162: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
163: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
164: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
165: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
166: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
167:

Line 164: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);

160: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
161: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
162: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
163: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
164: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
165: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
166: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
167:
168: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

Line 165: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);

161: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
162: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
163: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
164: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
165: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
166: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
167:
168: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
169:

Line 166: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);

162: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
163: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
164: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
165: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
166: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
167:
168: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
169:
170: l_fyi_notification := SUBSTR(l_string

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

164: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
165: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
166: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
167:
168: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
169:
170: l_fyi_notification := SUBSTR(l_string
171: || fnd_global.local_chr (10)
172: || l_string1

Line 324: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVED_SUBJ');

320: l_effective_date,
321: l_offer_adj_name;
322: CLOSE c_offer_adj_info;
323:
324: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVED_SUBJ');
325: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
326: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
327: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
328: l_string := Substr(FND_MESSAGE.Get,1,1000);

Line 325: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);

321: l_offer_adj_name;
322: CLOSE c_offer_adj_info;
323:
324: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVED_SUBJ');
325: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
326: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
327: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
328: l_string := Substr(FND_MESSAGE.Get,1,1000);
329:

Line 326: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);

322: CLOSE c_offer_adj_info;
323:
324: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVED_SUBJ');
325: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
326: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
327: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
328: l_string := Substr(FND_MESSAGE.Get,1,1000);
329:
330: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVED_INFO');

Line 327: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);

323:
324: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVED_SUBJ');
325: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
326: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
327: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
328: l_string := Substr(FND_MESSAGE.Get,1,1000);
329:
330: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVED_INFO');
331: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);

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

324: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVED_SUBJ');
325: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
326: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
327: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
328: l_string := Substr(FND_MESSAGE.Get,1,1000);
329:
330: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVED_INFO');
331: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
332: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

Line 330: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVED_INFO');

326: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
327: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
328: l_string := Substr(FND_MESSAGE.Get,1,1000);
329:
330: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVED_INFO');
331: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
332: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
333: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
334: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);

Line 331: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);

327: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
328: l_string := Substr(FND_MESSAGE.Get,1,1000);
329:
330: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVED_INFO');
331: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
332: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
333: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
334: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
335: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);

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

328: l_string := Substr(FND_MESSAGE.Get,1,1000);
329:
330: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVED_INFO');
331: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
332: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
333: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
334: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
335: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
336: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);

Line 333: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);

329:
330: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVED_INFO');
331: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
332: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
333: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
334: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
335: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
336: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
337: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);

Line 334: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);

330: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVED_INFO');
331: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
332: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
333: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
334: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
335: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
336: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
337: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
338: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);

Line 335: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);

331: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
332: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
333: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
334: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
335: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
336: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
337: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
338: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
339: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);

Line 336: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);

332: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
333: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
334: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
335: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
336: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
337: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
338: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
339: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
340:

Line 337: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);

333: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
334: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
335: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
336: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
337: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
338: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
339: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
340:
341: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

Line 338: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);

334: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
335: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
336: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
337: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
338: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
339: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
340:
341: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
342:

Line 339: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);

335: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
336: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
337: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
338: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
339: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
340:
341: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
342:
343: l_appr_notification := SUBSTR(l_string

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

337: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
338: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
339: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
340:
341: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
342:
343: l_appr_notification := SUBSTR(l_string
344: || fnd_global.local_chr (10)
345: || l_string1

Line 497: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_REJECTED_SUBJ');

493: l_effective_date,
494: l_offer_adj_name;
495: CLOSE c_offer_adj_info;
496:
497: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_REJECTED_SUBJ');
498: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
499: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
500: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
501: l_string := Substr(FND_MESSAGE.Get,1,1000);

Line 498: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);

494: l_offer_adj_name;
495: CLOSE c_offer_adj_info;
496:
497: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_REJECTED_SUBJ');
498: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
499: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
500: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
501: l_string := Substr(FND_MESSAGE.Get,1,1000);
502:

Line 499: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);

495: CLOSE c_offer_adj_info;
496:
497: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_REJECTED_SUBJ');
498: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
499: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
500: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
501: l_string := Substr(FND_MESSAGE.Get,1,1000);
502:
503: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_REJECTED_INFO');

Line 500: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);

496:
497: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_REJECTED_SUBJ');
498: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
499: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
500: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
501: l_string := Substr(FND_MESSAGE.Get,1,1000);
502:
503: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_REJECTED_INFO');
504: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);

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

497: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_REJECTED_SUBJ');
498: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
499: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
500: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
501: l_string := Substr(FND_MESSAGE.Get,1,1000);
502:
503: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_REJECTED_INFO');
504: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
505: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

Line 503: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_REJECTED_INFO');

499: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
500: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
501: l_string := Substr(FND_MESSAGE.Get,1,1000);
502:
503: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_REJECTED_INFO');
504: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
505: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
506: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
507: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);

Line 504: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);

500: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
501: l_string := Substr(FND_MESSAGE.Get,1,1000);
502:
503: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_REJECTED_INFO');
504: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
505: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
506: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
507: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
508: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);

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

501: l_string := Substr(FND_MESSAGE.Get,1,1000);
502:
503: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_REJECTED_INFO');
504: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
505: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
506: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
507: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
508: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
509: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);

Line 506: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);

502:
503: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_REJECTED_INFO');
504: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
505: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
506: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
507: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
508: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
509: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
510: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);

Line 507: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);

503: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_REJECTED_INFO');
504: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
505: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
506: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
507: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
508: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
509: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
510: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
511: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);

Line 508: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);

504: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
505: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
506: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
507: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
508: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
509: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
510: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
511: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
512: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);

Line 509: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);

505: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
506: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
507: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
508: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
509: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
510: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
511: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
512: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
513: fnd_message.set_token('COMMENTS_NOTES', l_note, false);

Line 510: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);

506: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
507: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
508: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
509: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
510: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
511: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
512: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
513: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
514:

Line 511: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);

507: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
508: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
509: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
510: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
511: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
512: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
513: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
514:
515: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

Line 512: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);

508: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
509: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
510: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
511: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
512: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
513: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
514:
515: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
516:

Line 513: fnd_message.set_token('COMMENTS_NOTES', l_note, false);

509: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
510: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
511: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
512: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
513: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
514:
515: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
516:
517:

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

511: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
512: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
513: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
514:
515: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
516:
517:
518: l_rej_notification := SUBSTR(l_string
519: || fnd_global.local_chr (10)

Line 675: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVAL_SUBJ');

671: l_effective_date,
672: l_offer_adj_name;
673: CLOSE c_offer_adj_info;
674:
675: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVAL_SUBJ');
676: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
677: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
678: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
679: l_string := Substr(FND_MESSAGE.Get,1,1000);

Line 676: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);

672: l_offer_adj_name;
673: CLOSE c_offer_adj_info;
674:
675: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVAL_SUBJ');
676: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
677: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
678: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
679: l_string := Substr(FND_MESSAGE.Get,1,1000);
680:

Line 677: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);

673: CLOSE c_offer_adj_info;
674:
675: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVAL_SUBJ');
676: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
677: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
678: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
679: l_string := Substr(FND_MESSAGE.Get,1,1000);
680:
681: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVAL_INFO');

Line 678: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);

674:
675: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVAL_SUBJ');
676: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
677: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
678: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
679: l_string := Substr(FND_MESSAGE.Get,1,1000);
680:
681: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVAL_INFO');
682: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);

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

675: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVAL_SUBJ');
676: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
677: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
678: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
679: l_string := Substr(FND_MESSAGE.Get,1,1000);
680:
681: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVAL_INFO');
682: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
683: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);

Line 681: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVAL_INFO');

677: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
678: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
679: l_string := Substr(FND_MESSAGE.Get,1,1000);
680:
681: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVAL_INFO');
682: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
683: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
684: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
685: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);

Line 682: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);

678: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
679: l_string := Substr(FND_MESSAGE.Get,1,1000);
680:
681: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVAL_INFO');
682: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
683: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
684: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
685: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
686: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);

Line 683: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);

679: l_string := Substr(FND_MESSAGE.Get,1,1000);
680:
681: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVAL_INFO');
682: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
683: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
684: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
685: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
686: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
687: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);

Line 684: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);

680:
681: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVAL_INFO');
682: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
683: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
684: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
685: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
686: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
687: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
688: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);

Line 685: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);

681: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVAL_INFO');
682: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
683: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
684: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
685: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
686: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
687: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
688: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
689: fnd_message.set_token('COMMENTS_NOTES', l_note, false);

Line 686: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);

682: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
683: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
684: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
685: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
686: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
687: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
688: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
689: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
690:

Line 687: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);

683: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
684: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
685: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
686: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
687: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
688: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
689: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
690:
691: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

Line 688: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);

684: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
685: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
686: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
687: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
688: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
689: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
690:
691: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
692:

Line 689: fnd_message.set_token('COMMENTS_NOTES', l_note, false);

685: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
686: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
687: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
688: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
689: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
690:
691: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
692:
693: l_appreq_notification := l_string

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

687: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
688: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
689: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
690:
691: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
692:
693: l_appreq_notification := l_string
694: || fnd_global.local_chr (10)
695: || l_string1

Line 848: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPR_REM_SUBJ');

844: l_effective_date,
845: l_offer_adj_name;
846: CLOSE c_offer_adj_info;
847:
848: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPR_REM_SUBJ');
849: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
850: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
851: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
852: l_string := Substr(FND_MESSAGE.Get,1,1000);

Line 849: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);

845: l_offer_adj_name;
846: CLOSE c_offer_adj_info;
847:
848: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPR_REM_SUBJ');
849: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
850: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
851: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
852: l_string := Substr(FND_MESSAGE.Get,1,1000);
853:

Line 850: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);

846: CLOSE c_offer_adj_info;
847:
848: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPR_REM_SUBJ');
849: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
850: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
851: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
852: l_string := Substr(FND_MESSAGE.Get,1,1000);
853:
854: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPR_REM_INFO');

Line 851: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);

847:
848: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPR_REM_SUBJ');
849: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
850: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
851: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
852: l_string := Substr(FND_MESSAGE.Get,1,1000);
853:
854: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPR_REM_INFO');
855: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);

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

848: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPR_REM_SUBJ');
849: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
850: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
851: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
852: l_string := Substr(FND_MESSAGE.Get,1,1000);
853:
854: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPR_REM_INFO');
855: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
856: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);

Line 854: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPR_REM_INFO');

850: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
851: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
852: l_string := Substr(FND_MESSAGE.Get,1,1000);
853:
854: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPR_REM_INFO');
855: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
856: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
857: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
858: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);

Line 855: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);

851: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
852: l_string := Substr(FND_MESSAGE.Get,1,1000);
853:
854: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPR_REM_INFO');
855: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
856: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
857: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
858: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
859: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);

Line 856: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);

852: l_string := Substr(FND_MESSAGE.Get,1,1000);
853:
854: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPR_REM_INFO');
855: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
856: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
857: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
858: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
859: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
860: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);

Line 857: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);

853:
854: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPR_REM_INFO');
855: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
856: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
857: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
858: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
859: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
860: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
861: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);

Line 858: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);

854: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPR_REM_INFO');
855: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
856: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
857: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
858: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
859: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
860: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
861: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
862: fnd_message.set_token('COMMENTS_NOTES', l_note, false);

Line 859: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);

855: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
856: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
857: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
858: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
859: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
860: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
861: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
862: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
863:

Line 860: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);

856: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
857: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
858: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
859: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
860: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
861: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
862: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
863:
864: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

Line 861: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);

857: fnd_message.set_token ('OFFER_TYPE', l_offer_type, FALSE);
858: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
859: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
860: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
861: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
862: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
863:
864: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
865:

Line 862: fnd_message.set_token('COMMENTS_NOTES', l_note, false);

858: fnd_message.set_token ('START_DATE', l_start_date_active, FALSE);
859: fnd_message.set_token ('END_DATE', l_end_date_active, FALSE);
860: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
861: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
862: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
863:
864: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
865:
866:

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

860: fnd_message.set_token ('SETTLEMENT_NAME', l_settlement_name, FALSE);
861: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
862: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
863:
864: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
865:
866:
867: l_apprem_notification := l_string
868: || fnd_global.local_chr (10)

Line 1087: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_FORWARD_SUBJ');

1083: );
1084:
1085: --- set all the subjects here
1086:
1087: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_FORWARD_SUBJ');
1088: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
1089: fnd_message.set_token ('OFFER_NAME', l_object_details.name, FALSE);
1090: l_string := SUBSTR(fnd_message.get,1,1000);
1091:

Line 1088: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);

1084:
1085: --- set all the subjects here
1086:
1087: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_FORWARD_SUBJ');
1088: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
1089: fnd_message.set_token ('OFFER_NAME', l_object_details.name, FALSE);
1090: l_string := SUBSTR(fnd_message.get,1,1000);
1091:
1092: wf_engine.setitemattrtext(

Line 1089: fnd_message.set_token ('OFFER_NAME', l_object_details.name, FALSE);

1085: --- set all the subjects here
1086:
1087: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_FORWARD_SUBJ');
1088: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
1089: fnd_message.set_token ('OFFER_NAME', l_object_details.name, FALSE);
1090: l_string := SUBSTR(fnd_message.get,1,1000);
1091:
1092: wf_engine.setitemattrtext(
1093: itemtype => itemtype

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

1086:
1087: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_FORWARD_SUBJ');
1088: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
1089: fnd_message.set_token ('OFFER_NAME', l_object_details.name, FALSE);
1090: l_string := SUBSTR(fnd_message.get,1,1000);
1091:
1092: wf_engine.setitemattrtext(
1093: itemtype => itemtype
1094: ,itemkey => itemkey

Line 1099: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVAL_SUBJ');

1095: ,aname => 'FYI_SUBJECT'
1096: ,avalue => l_string
1097: );
1098:
1099: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVAL_SUBJ');
1100: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
1101: fnd_message.set_token ('OFFER_NAME', l_object_details.name, FALSE);
1102: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
1103: l_string := Substr(FND_MESSAGE.Get,1,1000);

Line 1100: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);

1096: ,avalue => l_string
1097: );
1098:
1099: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVAL_SUBJ');
1100: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
1101: fnd_message.set_token ('OFFER_NAME', l_object_details.name, FALSE);
1102: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
1103: l_string := Substr(FND_MESSAGE.Get,1,1000);
1104:

Line 1101: fnd_message.set_token ('OFFER_NAME', l_object_details.name, FALSE);

1097: );
1098:
1099: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVAL_SUBJ');
1100: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
1101: fnd_message.set_token ('OFFER_NAME', l_object_details.name, FALSE);
1102: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
1103: l_string := Substr(FND_MESSAGE.Get,1,1000);
1104:
1105: wf_engine.setitemattrtext(

Line 1102: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);

1098:
1099: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVAL_SUBJ');
1100: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
1101: fnd_message.set_token ('OFFER_NAME', l_object_details.name, FALSE);
1102: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
1103: l_string := Substr(FND_MESSAGE.Get,1,1000);
1104:
1105: wf_engine.setitemattrtext(
1106: itemtype => itemtype

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

1099: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVAL_SUBJ');
1100: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
1101: fnd_message.set_token ('OFFER_NAME', l_object_details.name, FALSE);
1102: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
1103: l_string := Substr(FND_MESSAGE.Get,1,1000);
1104:
1105: wf_engine.setitemattrtext(
1106: itemtype => itemtype
1107: ,itemkey => itemkey

Line 1113: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVED_SUBJ');

1109: ,avalue => l_string
1110: );
1111:
1112:
1113: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVED_SUBJ');
1114: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
1115: fnd_message.set_token ('OFFER_NAME', l_object_details.name, FALSE);
1116: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
1117: l_string := Substr(FND_MESSAGE.Get,1,1000);

Line 1114: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);

1110: );
1111:
1112:
1113: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVED_SUBJ');
1114: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
1115: fnd_message.set_token ('OFFER_NAME', l_object_details.name, FALSE);
1116: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
1117: l_string := Substr(FND_MESSAGE.Get,1,1000);
1118:

Line 1115: fnd_message.set_token ('OFFER_NAME', l_object_details.name, FALSE);

1111:
1112:
1113: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVED_SUBJ');
1114: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
1115: fnd_message.set_token ('OFFER_NAME', l_object_details.name, FALSE);
1116: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
1117: l_string := Substr(FND_MESSAGE.Get,1,1000);
1118:
1119: wf_engine.setitemattrtext(

Line 1116: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);

1112:
1113: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVED_SUBJ');
1114: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
1115: fnd_message.set_token ('OFFER_NAME', l_object_details.name, FALSE);
1116: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
1117: l_string := Substr(FND_MESSAGE.Get,1,1000);
1118:
1119: wf_engine.setitemattrtext(
1120: itemtype => itemtype

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

1113: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_APPROVED_SUBJ');
1114: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
1115: fnd_message.set_token ('OFFER_NAME', l_object_details.name, FALSE);
1116: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
1117: l_string := Substr(FND_MESSAGE.Get,1,1000);
1118:
1119: wf_engine.setitemattrtext(
1120: itemtype => itemtype
1121: ,itemkey => itemkey

Line 1126: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_REJECTED_SUBJ');

1122: ,aname => 'APRV_SUBJECT'
1123: ,avalue => l_string
1124: );
1125:
1126: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_REJECTED_SUBJ');
1127: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
1128: fnd_message.set_token ('OFFER_NAME', l_object_details.name , FALSE);
1129: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
1130: l_string := Substr(FND_MESSAGE.Get,1,1000);

Line 1127: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);

1123: ,avalue => l_string
1124: );
1125:
1126: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_REJECTED_SUBJ');
1127: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
1128: fnd_message.set_token ('OFFER_NAME', l_object_details.name , FALSE);
1129: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
1130: l_string := Substr(FND_MESSAGE.Get,1,1000);
1131:

Line 1128: fnd_message.set_token ('OFFER_NAME', l_object_details.name , FALSE);

1124: );
1125:
1126: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_REJECTED_SUBJ');
1127: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
1128: fnd_message.set_token ('OFFER_NAME', l_object_details.name , FALSE);
1129: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
1130: l_string := Substr(FND_MESSAGE.Get,1,1000);
1131:
1132: wf_engine.setitemattrtext(

Line 1129: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);

1125:
1126: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_REJECTED_SUBJ');
1127: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
1128: fnd_message.set_token ('OFFER_NAME', l_object_details.name , FALSE);
1129: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
1130: l_string := Substr(FND_MESSAGE.Get,1,1000);
1131:
1132: wf_engine.setitemattrtext(
1133: itemtype => itemtype

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

1126: fnd_message.set_name ('OZF', 'OZF_OFFRADJ_NTF_REJECTED_SUBJ');
1127: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
1128: fnd_message.set_token ('OFFER_NAME', l_object_details.name , FALSE);
1129: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
1130: l_string := Substr(FND_MESSAGE.Get,1,1000);
1131:
1132: wf_engine.setitemattrtext(
1133: itemtype => itemtype
1134: ,itemkey => itemkey