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.MRP_FORECAST_INTERFACE_PK dependencies on FND_MESSAGE

Line 88: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');

84: --dbms_output.put_line('Action '||forecast_interface(counter).action);
85: /* Begin change for Bug 1849709 */
86: IF forecast_interface(counter).action IS NOT NULL AND
87: forecast_interface(counter).action not in ('I','U','D') THEN
88: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
89: fnd_message.set_token('ENTITY', 'E_FORECAST_ACTION', TRUE);
90: fnd_message.set_token('VALUE',
91: forecast_interface(counter).action);
92: error_message := fnd_message.get;

Line 89: fnd_message.set_token('ENTITY', 'E_FORECAST_ACTION', TRUE);

85: /* Begin change for Bug 1849709 */
86: IF forecast_interface(counter).action IS NOT NULL AND
87: forecast_interface(counter).action not in ('I','U','D') THEN
88: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
89: fnd_message.set_token('ENTITY', 'E_FORECAST_ACTION', TRUE);
90: fnd_message.set_token('VALUE',
91: forecast_interface(counter).action);
92: error_message := fnd_message.get;
93: set_interface_error(counter, forecast_interface, error_message);

Line 90: fnd_message.set_token('VALUE',

86: IF forecast_interface(counter).action IS NOT NULL AND
87: forecast_interface(counter).action not in ('I','U','D') THEN
88: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
89: fnd_message.set_token('ENTITY', 'E_FORECAST_ACTION', TRUE);
90: fnd_message.set_token('VALUE',
91: forecast_interface(counter).action);
92: error_message := fnd_message.get;
93: set_interface_error(counter, forecast_interface, error_message);
94: -- IF mrdebug = TRUE THEN

Line 92: error_message := fnd_message.get;

88: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
89: fnd_message.set_token('ENTITY', 'E_FORECAST_ACTION', TRUE);
90: fnd_message.set_token('VALUE',
91: forecast_interface(counter).action);
92: error_message := fnd_message.get;
93: set_interface_error(counter, forecast_interface, error_message);
94: -- IF mrdebug = TRUE THEN
95: -- dbms_output.put_line('Error for action - '||
96: -- forecast_interface(counter).action);

Line 127: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');

123: -- forecast_interface(counter).quantity > 99999999.9 OR
124: -- forecast_interface(counter).quantity = 0
125: AND delete_row = FALSE
126: THEN
127: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
128: fnd_message.set_token('ENTITY', 'E_FORECAST_QTY', TRUE);
129: fnd_message.set_token('VALUE',
130: to_char(forecast_interface(counter).quantity));
131: error_message := fnd_message.get;

Line 128: fnd_message.set_token('ENTITY', 'E_FORECAST_QTY', TRUE);

124: -- forecast_interface(counter).quantity = 0
125: AND delete_row = FALSE
126: THEN
127: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
128: fnd_message.set_token('ENTITY', 'E_FORECAST_QTY', TRUE);
129: fnd_message.set_token('VALUE',
130: to_char(forecast_interface(counter).quantity));
131: error_message := fnd_message.get;
132: set_interface_error(counter, forecast_interface, error_message);

Line 129: fnd_message.set_token('VALUE',

125: AND delete_row = FALSE
126: THEN
127: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
128: fnd_message.set_token('ENTITY', 'E_FORECAST_QTY', TRUE);
129: fnd_message.set_token('VALUE',
130: to_char(forecast_interface(counter).quantity));
131: error_message := fnd_message.get;
132: set_interface_error(counter, forecast_interface, error_message);
133: -- IF mrdebug = TRUE THEN

Line 131: error_message := fnd_message.get;

127: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
128: fnd_message.set_token('ENTITY', 'E_FORECAST_QTY', TRUE);
129: fnd_message.set_token('VALUE',
130: to_char(forecast_interface(counter).quantity));
131: error_message := fnd_message.get;
132: set_interface_error(counter, forecast_interface, error_message);
133: -- IF mrdebug = TRUE THEN
134: -- dbms_output.put_line('Error for Quantity - '||
135: -- to_char(forecast_interface(counter).quantity));

Line 149: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');

145:
146: IF forecast_interface(counter).confidence_percentage <= 0 OR
147: forecast_interface(counter).confidence_percentage > 100
148: THEN
149: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
150: fnd_message.set_token('ENTITY', 'E_CONFIDENCE_PERCENT', TRUE);
151: fnd_message.set_token('VALUE',
152: to_char(forecast_interface(counter).confidence_percentage));
153: error_message := fnd_message.get;

Line 150: fnd_message.set_token('ENTITY', 'E_CONFIDENCE_PERCENT', TRUE);

146: IF forecast_interface(counter).confidence_percentage <= 0 OR
147: forecast_interface(counter).confidence_percentage > 100
148: THEN
149: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
150: fnd_message.set_token('ENTITY', 'E_CONFIDENCE_PERCENT', TRUE);
151: fnd_message.set_token('VALUE',
152: to_char(forecast_interface(counter).confidence_percentage));
153: error_message := fnd_message.get;
154: set_interface_error(counter, forecast_interface, error_message);

Line 151: fnd_message.set_token('VALUE',

147: forecast_interface(counter).confidence_percentage > 100
148: THEN
149: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
150: fnd_message.set_token('ENTITY', 'E_CONFIDENCE_PERCENT', TRUE);
151: fnd_message.set_token('VALUE',
152: to_char(forecast_interface(counter).confidence_percentage));
153: error_message := fnd_message.get;
154: set_interface_error(counter, forecast_interface, error_message);
155: -- IF mrdebug = TRUE THEN

Line 153: error_message := fnd_message.get;

149: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
150: fnd_message.set_token('ENTITY', 'E_CONFIDENCE_PERCENT', TRUE);
151: fnd_message.set_token('VALUE',
152: to_char(forecast_interface(counter).confidence_percentage));
153: error_message := fnd_message.get;
154: set_interface_error(counter, forecast_interface, error_message);
155: -- IF mrdebug = TRUE THEN
156: -- dbms_output.put_line('Error for Confidence Pctg - '||
157: -- to_char(forecast_interface(counter).confidence_percentage));

Line 174: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');

170: SHIFT_INVALID_DATE_BWD AND
171: forecast_interface(counter).workday_control <>
172: REJECT_INVALID_DATE
173: THEN
174: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
175: fnd_message.set_token('ENTITY', 'E_WORKDAY_CONTROL', TRUE);
176: fnd_message.set_token('VALUE',
177: to_char(forecast_interface(counter).workday_control), FALSE);
178: error_message := fnd_message.get;

Line 175: fnd_message.set_token('ENTITY', 'E_WORKDAY_CONTROL', TRUE);

171: forecast_interface(counter).workday_control <>
172: REJECT_INVALID_DATE
173: THEN
174: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
175: fnd_message.set_token('ENTITY', 'E_WORKDAY_CONTROL', TRUE);
176: fnd_message.set_token('VALUE',
177: to_char(forecast_interface(counter).workday_control), FALSE);
178: error_message := fnd_message.get;
179: set_interface_error(counter, forecast_interface, error_message);

Line 176: fnd_message.set_token('VALUE',

172: REJECT_INVALID_DATE
173: THEN
174: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
175: fnd_message.set_token('ENTITY', 'E_WORKDAY_CONTROL', TRUE);
176: fnd_message.set_token('VALUE',
177: to_char(forecast_interface(counter).workday_control), FALSE);
178: error_message := fnd_message.get;
179: set_interface_error(counter, forecast_interface, error_message);
180: -- IF mrdebug = TRUE THEN

Line 178: error_message := fnd_message.get;

174: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
175: fnd_message.set_token('ENTITY', 'E_WORKDAY_CONTROL', TRUE);
176: fnd_message.set_token('VALUE',
177: to_char(forecast_interface(counter).workday_control), FALSE);
178: error_message := fnd_message.get;
179: set_interface_error(counter, forecast_interface, error_message);
180: -- IF mrdebug = TRUE THEN
181: -- dbms_output.put_line('Error for Workday control - '||
182: -- to_char(forecast_interface(counter).workday_control));

Line 201: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');

197: forecast_interface(counter).forecast_designator;
198: IF SQL%NOTFOUND THEN
199: IF forecast_interface(counter).transaction_id > var_max_trx_id
200: THEN
201: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
202: fnd_message.set_token('ENTITY',
203: 'E_TRANSACTION_ID', TRUE);
204: fnd_message.set_token('VALUE',
205: to_char(forecast_interface(counter).transaction_id));

Line 202: fnd_message.set_token('ENTITY',

198: IF SQL%NOTFOUND THEN
199: IF forecast_interface(counter).transaction_id > var_max_trx_id
200: THEN
201: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
202: fnd_message.set_token('ENTITY',
203: 'E_TRANSACTION_ID', TRUE);
204: fnd_message.set_token('VALUE',
205: to_char(forecast_interface(counter).transaction_id));
206: error_message := fnd_message.get;

Line 204: fnd_message.set_token('VALUE',

200: THEN
201: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
202: fnd_message.set_token('ENTITY',
203: 'E_TRANSACTION_ID', TRUE);
204: fnd_message.set_token('VALUE',
205: to_char(forecast_interface(counter).transaction_id));
206: error_message := fnd_message.get;
207: set_interface_error(counter,
208: forecast_interface, error_message);

Line 206: error_message := fnd_message.get;

202: fnd_message.set_token('ENTITY',
203: 'E_TRANSACTION_ID', TRUE);
204: fnd_message.set_token('VALUE',
205: to_char(forecast_interface(counter).transaction_id));
206: error_message := fnd_message.get;
207: set_interface_error(counter,
208: forecast_interface, error_message);
209: -- IF mrdebug = TRUE THEN
210: -- dbms_output.put_line('Error for Transaction Id - '||

Line 215: fnd_message.set_name('MRP', 'IMP-INVALID TRAN_ID');

211: -- to_char(forecast_interface(counter).transaction_id));
212: -- END IF;
213: goto skip_row;
214: ELSE
215: fnd_message.set_name('MRP', 'IMP-INVALID TRAN_ID');
216: error_message := fnd_message.get;
217: set_interface_error(counter,
218: forecast_interface, error_message);
219: -- IF mrdebug = TRUE THEN

Line 216: error_message := fnd_message.get;

212: -- END IF;
213: goto skip_row;
214: ELSE
215: fnd_message.set_name('MRP', 'IMP-INVALID TRAN_ID');
216: error_message := fnd_message.get;
217: set_interface_error(counter,
218: forecast_interface, error_message);
219: -- IF mrdebug = TRUE THEN
220: -- dbms_output.put_line('Error for Transaction Id - '||

Line 240: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');

236: AND process_enabled_flag = 'N'; /* 1485309 */
237:
238: EXCEPTION
239: WHEN no_data_found THEN
240: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
241: fnd_message.set_token('ENTITY', 'E_ORGANIZATION', TRUE);
242: fnd_message.set_token('VALUE',
243: to_char(forecast_interface(counter).organization_id));
244: error_message := fnd_message.get;

Line 241: fnd_message.set_token('ENTITY', 'E_ORGANIZATION', TRUE);

237:
238: EXCEPTION
239: WHEN no_data_found THEN
240: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
241: fnd_message.set_token('ENTITY', 'E_ORGANIZATION', TRUE);
242: fnd_message.set_token('VALUE',
243: to_char(forecast_interface(counter).organization_id));
244: error_message := fnd_message.get;
245: set_interface_error(counter, forecast_interface, error_message);

Line 242: fnd_message.set_token('VALUE',

238: EXCEPTION
239: WHEN no_data_found THEN
240: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
241: fnd_message.set_token('ENTITY', 'E_ORGANIZATION', TRUE);
242: fnd_message.set_token('VALUE',
243: to_char(forecast_interface(counter).organization_id));
244: error_message := fnd_message.get;
245: set_interface_error(counter, forecast_interface, error_message);
246: -- IF mrdebug = TRUE THEN

Line 244: error_message := fnd_message.get;

240: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
241: fnd_message.set_token('ENTITY', 'E_ORGANIZATION', TRUE);
242: fnd_message.set_token('VALUE',
243: to_char(forecast_interface(counter).organization_id));
244: error_message := fnd_message.get;
245: set_interface_error(counter, forecast_interface, error_message);
246: -- IF mrdebug = TRUE THEN
247: -- dbms_output.put_line('Error for Organization Id - '||
248: -- to_char(forecast_interface(counter).organization_id));

Line 264: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');

260: forecast_interface(counter).inventory_item_id;
261:
262: EXCEPTION
263: WHEN no_data_found THEN
264: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
265: fnd_message.set_token('ENTITY', 'E_INVENTORY_ITEM', TRUE);
266: fnd_message.set_token('VALUE',
267: to_char(forecast_interface(counter).inventory_item_id));
268: error_message := fnd_message.get;

Line 265: fnd_message.set_token('ENTITY', 'E_INVENTORY_ITEM', TRUE);

261:
262: EXCEPTION
263: WHEN no_data_found THEN
264: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
265: fnd_message.set_token('ENTITY', 'E_INVENTORY_ITEM', TRUE);
266: fnd_message.set_token('VALUE',
267: to_char(forecast_interface(counter).inventory_item_id));
268: error_message := fnd_message.get;
269: set_interface_error(counter, forecast_interface, error_message);

Line 266: fnd_message.set_token('VALUE',

262: EXCEPTION
263: WHEN no_data_found THEN
264: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
265: fnd_message.set_token('ENTITY', 'E_INVENTORY_ITEM', TRUE);
266: fnd_message.set_token('VALUE',
267: to_char(forecast_interface(counter).inventory_item_id));
268: error_message := fnd_message.get;
269: set_interface_error(counter, forecast_interface, error_message);
270: -- IF mrdebug = TRUE THEN

Line 268: error_message := fnd_message.get;

264: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
265: fnd_message.set_token('ENTITY', 'E_INVENTORY_ITEM', TRUE);
266: fnd_message.set_token('VALUE',
267: to_char(forecast_interface(counter).inventory_item_id));
268: error_message := fnd_message.get;
269: set_interface_error(counter, forecast_interface, error_message);
270: -- IF mrdebug = TRUE THEN
271: -- dbms_output.put_line('Error for Item - '||
272: -- to_char(forecast_interface(counter).inventory_item_id));

Line 290: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');

286: forecast_interface(counter).organization_id;
287:
288: EXCEPTION
289: WHEN no_data_found THEN
290: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
291: fnd_message.set_token('ENTITY',
292: 'E_FORECAST_NAME', TRUE);
293: fnd_message.set_token('VALUE',
294: forecast_interface(counter).forecast_designator);

Line 291: fnd_message.set_token('ENTITY',

287:
288: EXCEPTION
289: WHEN no_data_found THEN
290: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
291: fnd_message.set_token('ENTITY',
292: 'E_FORECAST_NAME', TRUE);
293: fnd_message.set_token('VALUE',
294: forecast_interface(counter).forecast_designator);
295: error_message := fnd_message.get;

Line 293: fnd_message.set_token('VALUE',

289: WHEN no_data_found THEN
290: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
291: fnd_message.set_token('ENTITY',
292: 'E_FORECAST_NAME', TRUE);
293: fnd_message.set_token('VALUE',
294: forecast_interface(counter).forecast_designator);
295: error_message := fnd_message.get;
296: set_interface_error(counter, forecast_interface,
297: error_message);

Line 295: error_message := fnd_message.get;

291: fnd_message.set_token('ENTITY',
292: 'E_FORECAST_NAME', TRUE);
293: fnd_message.set_token('VALUE',
294: forecast_interface(counter).forecast_designator);
295: error_message := fnd_message.get;
296: set_interface_error(counter, forecast_interface,
297: error_message);
298: -- IF mrdebug = TRUE THEN
299: -- dbms_output.put_line('Error for Forecast name - '||

Line 314: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');

310: IF forecast_interface(counter).bucket_type <> 1 AND
311: forecast_interface(counter).bucket_type <> 2 AND
312: forecast_interface(counter).bucket_type <> 3
313: THEN
314: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
315: fnd_message.set_token('ENTITY', 'EC_BUCKET_TYPE', TRUE);
316: fnd_message.set_token('VALUE',
317: to_char(forecast_interface(counter).bucket_type));
318: error_message := fnd_message.get;

Line 315: fnd_message.set_token('ENTITY', 'EC_BUCKET_TYPE', TRUE);

311: forecast_interface(counter).bucket_type <> 2 AND
312: forecast_interface(counter).bucket_type <> 3
313: THEN
314: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
315: fnd_message.set_token('ENTITY', 'EC_BUCKET_TYPE', TRUE);
316: fnd_message.set_token('VALUE',
317: to_char(forecast_interface(counter).bucket_type));
318: error_message := fnd_message.get;
319: set_interface_error(counter, forecast_interface, error_message);

Line 316: fnd_message.set_token('VALUE',

312: forecast_interface(counter).bucket_type <> 3
313: THEN
314: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
315: fnd_message.set_token('ENTITY', 'EC_BUCKET_TYPE', TRUE);
316: fnd_message.set_token('VALUE',
317: to_char(forecast_interface(counter).bucket_type));
318: error_message := fnd_message.get;
319: set_interface_error(counter, forecast_interface, error_message);
320: -- IF mrdebug = TRUE THEN

Line 318: error_message := fnd_message.get;

314: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
315: fnd_message.set_token('ENTITY', 'EC_BUCKET_TYPE', TRUE);
316: fnd_message.set_token('VALUE',
317: to_char(forecast_interface(counter).bucket_type));
318: error_message := fnd_message.get;
319: set_interface_error(counter, forecast_interface, error_message);
320: -- IF mrdebug = TRUE THEN
321: -- dbms_output.put_line('Error for Bucket type - '||
322: -- to_char(forecast_interface(counter).bucket_type));

Line 329: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');

325: END IF;
326:
327: IF forecast_interface(counter).forecast_date is null
328: THEN
329: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
330: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
331: fnd_message.set_token('VALUE', 'NULL');
332: error_message := fnd_message.get;
333: set_interface_error(counter, forecast_interface, error_message);

Line 330: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);

326:
327: IF forecast_interface(counter).forecast_date is null
328: THEN
329: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
330: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
331: fnd_message.set_token('VALUE', 'NULL');
332: error_message := fnd_message.get;
333: set_interface_error(counter, forecast_interface, error_message);
334: -- IF mrdebug = TRUE THEN

Line 331: fnd_message.set_token('VALUE', 'NULL');

327: IF forecast_interface(counter).forecast_date is null
328: THEN
329: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
330: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
331: fnd_message.set_token('VALUE', 'NULL');
332: error_message := fnd_message.get;
333: set_interface_error(counter, forecast_interface, error_message);
334: -- IF mrdebug = TRUE THEN
335: -- dbms_output.put_line('Error for Forecast date - NULL');

Line 332: error_message := fnd_message.get;

328: THEN
329: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
330: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
331: fnd_message.set_token('VALUE', 'NULL');
332: error_message := fnd_message.get;
333: set_interface_error(counter, forecast_interface, error_message);
334: -- IF mrdebug = TRUE THEN
335: -- dbms_output.put_line('Error for Forecast date - NULL');
336: -- END IF;

Line 346: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');

342: forecast_interface(counter).bucket_type,
343: forecast_interface(counter).workday_control,
344: forecast_interface(counter).organization_id) = FALSE
345: THEN
346: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
347: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
348: fnd_message.set_token('VALUE',
349: to_char(forecast_interface(counter).forecast_date));
350: error_message := fnd_message.get;

Line 347: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);

343: forecast_interface(counter).workday_control,
344: forecast_interface(counter).organization_id) = FALSE
345: THEN
346: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
347: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
348: fnd_message.set_token('VALUE',
349: to_char(forecast_interface(counter).forecast_date));
350: error_message := fnd_message.get;
351: set_interface_error(counter, forecast_interface, error_message);

Line 348: fnd_message.set_token('VALUE',

344: forecast_interface(counter).organization_id) = FALSE
345: THEN
346: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
347: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
348: fnd_message.set_token('VALUE',
349: to_char(forecast_interface(counter).forecast_date));
350: error_message := fnd_message.get;
351: set_interface_error(counter, forecast_interface, error_message);
352: -- IF mrdebug = TRUE THEN

Line 350: error_message := fnd_message.get;

346: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
347: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
348: fnd_message.set_token('VALUE',
349: to_char(forecast_interface(counter).forecast_date));
350: error_message := fnd_message.get;
351: set_interface_error(counter, forecast_interface, error_message);
352: -- IF mrdebug = TRUE THEN
353: -- dbms_output.put_line('Error for Forecast date - '||
354: -- to_char(forecast_interface(counter).forecast_date));

Line 366: fnd_message.set_name('MRP', 'IMP-invalid rate_end_date');

362: forecast_interface(counter).bucket_type,
363: forecast_interface(counter).workday_control,
364: forecast_interface(counter).organization_id) = FALSE
365: THEN
366: fnd_message.set_name('MRP', 'IMP-invalid rate_end_date');
367: error_message := fnd_message.get;
368: set_interface_error(counter, forecast_interface, error_message);
369: -- IF mrdebug = TRUE THEN
370: -- dbms_output.put_line('Error for Forecast end date - '||

Line 367: error_message := fnd_message.get;

363: forecast_interface(counter).workday_control,
364: forecast_interface(counter).organization_id) = FALSE
365: THEN
366: fnd_message.set_name('MRP', 'IMP-invalid rate_end_date');
367: error_message := fnd_message.get;
368: set_interface_error(counter, forecast_interface, error_message);
369: -- IF mrdebug = TRUE THEN
370: -- dbms_output.put_line('Error for Forecast end date - '||
371: -- to_char(forecast_interface(counter).forecast_end_date));

Line 376: fnd_message.set_name('MRP', 'IMP-invalid rate_end_date');

372: -- END IF;
373: goto skip_row;
374: END IF;
375: IF var_for_end_date < var_for_date THEN
376: fnd_message.set_name('MRP', 'IMP-invalid rate_end_date');
377: error_message := fnd_message.get;
378: set_interface_error(counter, forecast_interface, error_message);
379: -- IF mrdebug = TRUE THEN
380: -- dbms_output.put_line('Error for Forecast end date - '||

Line 377: error_message := fnd_message.get;

373: goto skip_row;
374: END IF;
375: IF var_for_end_date < var_for_date THEN
376: fnd_message.set_name('MRP', 'IMP-invalid rate_end_date');
377: error_message := fnd_message.get;
378: set_interface_error(counter, forecast_interface, error_message);
379: -- IF mrdebug = TRUE THEN
380: -- dbms_output.put_line('Error for Forecast end date - '||
381: -- to_char(forecast_interface(counter).forecast_end_date));

Line 400: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');

396: AND line_id = forecast_interface(counter).line_id;
397:
398: EXCEPTION
399: WHEN no_data_found THEN
400: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
401: fnd_message.set_token('ENTITY', 'E_LINE', TRUE);
402: fnd_message.set_token('VALUE',
403: to_char(forecast_interface(counter).line_id));
404: error_message := fnd_message.get;

Line 401: fnd_message.set_token('ENTITY', 'E_LINE', TRUE);

397:
398: EXCEPTION
399: WHEN no_data_found THEN
400: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
401: fnd_message.set_token('ENTITY', 'E_LINE', TRUE);
402: fnd_message.set_token('VALUE',
403: to_char(forecast_interface(counter).line_id));
404: error_message := fnd_message.get;
405: set_interface_error(counter, forecast_interface, error_message);

Line 402: fnd_message.set_token('VALUE',

398: EXCEPTION
399: WHEN no_data_found THEN
400: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
401: fnd_message.set_token('ENTITY', 'E_LINE', TRUE);
402: fnd_message.set_token('VALUE',
403: to_char(forecast_interface(counter).line_id));
404: error_message := fnd_message.get;
405: set_interface_error(counter, forecast_interface, error_message);
406: -- IF mrdebug = TRUE THEN

Line 404: error_message := fnd_message.get;

400: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
401: fnd_message.set_token('ENTITY', 'E_LINE', TRUE);
402: fnd_message.set_token('VALUE',
403: to_char(forecast_interface(counter).line_id));
404: error_message := fnd_message.get;
405: set_interface_error(counter, forecast_interface, error_message);
406: -- IF mrdebug = TRUE THEN
407: -- dbms_output.put_line('Error for Line - '||
408: -- to_char(forecast_interface(counter).line_id));

Line 428: error_message := SUBSTRB(fnd_message.get,1,240);

424: );
425: END IF;
426:
427: IF (p_result = 'E') THEN
428: error_message := SUBSTRB(fnd_message.get,1,240);
429: set_interface_error(counter, forecast_interface, error_message);
430: goto skip_row;
431: END IF;
432:

Line 745: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');

741:
742: IF adjust_date(p_start_date, l_new_start_date, 1, p_workday_control,
743: p_organization_id) = FALSE
744: THEN
745: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
746: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
747: fnd_message.set_token('VALUE', to_char(p_start_date));
748: fnd_msg_pub.add;
749: RAISE FND_API.G_EXC_ERROR;

Line 746: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);

742: IF adjust_date(p_start_date, l_new_start_date, 1, p_workday_control,
743: p_organization_id) = FALSE
744: THEN
745: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
746: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
747: fnd_message.set_token('VALUE', to_char(p_start_date));
748: fnd_msg_pub.add;
749: RAISE FND_API.G_EXC_ERROR;
750: END IF;

Line 747: fnd_message.set_token('VALUE', to_char(p_start_date));

743: p_organization_id) = FALSE
744: THEN
745: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
746: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
747: fnd_message.set_token('VALUE', to_char(p_start_date));
748: fnd_msg_pub.add;
749: RAISE FND_API.G_EXC_ERROR;
750: END IF;
751: IF adjust_date(p_end_date, l_new_end_date, 1, p_workday_control,

Line 754: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');

750: END IF;
751: IF adjust_date(p_end_date, l_new_end_date, 1, p_workday_control,
752: p_organization_id) = FALSE
753: THEN
754: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
755: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
756: fnd_message.set_token('VALUE', to_char(p_end_date));
757: fnd_msg_pub.add;
758: RAISE FND_API.G_EXC_ERROR;

Line 755: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);

751: IF adjust_date(p_end_date, l_new_end_date, 1, p_workday_control,
752: p_organization_id) = FALSE
753: THEN
754: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
755: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
756: fnd_message.set_token('VALUE', to_char(p_end_date));
757: fnd_msg_pub.add;
758: RAISE FND_API.G_EXC_ERROR;
759: END IF;

Line 756: fnd_message.set_token('VALUE', to_char(p_end_date));

752: p_organization_id) = FALSE
753: THEN
754: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
755: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
756: fnd_message.set_token('VALUE', to_char(p_end_date));
757: fnd_msg_pub.add;
758: RAISE FND_API.G_EXC_ERROR;
759: END IF;
760: