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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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