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 245: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');

241: /* OPM-CONVERGE-END*/
242:
243: EXCEPTION
244: WHEN no_data_found THEN
245: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
246: fnd_message.set_token('ENTITY', 'E_ORGANIZATION', TRUE);
247: fnd_message.set_token('VALUE',
248: to_char(forecast_interface(counter).organization_id));
249: error_message := fnd_message.get;

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

242:
243: EXCEPTION
244: WHEN no_data_found THEN
245: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
246: fnd_message.set_token('ENTITY', 'E_ORGANIZATION', TRUE);
247: fnd_message.set_token('VALUE',
248: to_char(forecast_interface(counter).organization_id));
249: error_message := fnd_message.get;
250: set_interface_error(counter, forecast_interface, error_message);

Line 247: fnd_message.set_token('VALUE',

243: EXCEPTION
244: WHEN no_data_found THEN
245: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
246: fnd_message.set_token('ENTITY', 'E_ORGANIZATION', TRUE);
247: fnd_message.set_token('VALUE',
248: to_char(forecast_interface(counter).organization_id));
249: error_message := fnd_message.get;
250: set_interface_error(counter, forecast_interface, error_message);
251: -- IF mrdebug = TRUE THEN

Line 249: error_message := fnd_message.get;

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

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

265: forecast_interface(counter).inventory_item_id;
266:
267: EXCEPTION
268: WHEN no_data_found THEN
269: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
270: fnd_message.set_token('ENTITY', 'E_INVENTORY_ITEM', TRUE);
271: fnd_message.set_token('VALUE',
272: to_char(forecast_interface(counter).inventory_item_id));
273: error_message := fnd_message.get;

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

266:
267: EXCEPTION
268: WHEN no_data_found THEN
269: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
270: fnd_message.set_token('ENTITY', 'E_INVENTORY_ITEM', TRUE);
271: fnd_message.set_token('VALUE',
272: to_char(forecast_interface(counter).inventory_item_id));
273: error_message := fnd_message.get;
274: set_interface_error(counter, forecast_interface, error_message);

Line 271: fnd_message.set_token('VALUE',

267: EXCEPTION
268: WHEN no_data_found THEN
269: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
270: fnd_message.set_token('ENTITY', 'E_INVENTORY_ITEM', TRUE);
271: fnd_message.set_token('VALUE',
272: to_char(forecast_interface(counter).inventory_item_id));
273: error_message := fnd_message.get;
274: set_interface_error(counter, forecast_interface, error_message);
275: -- IF mrdebug = TRUE THEN

Line 273: error_message := fnd_message.get;

269: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
270: fnd_message.set_token('ENTITY', 'E_INVENTORY_ITEM', TRUE);
271: fnd_message.set_token('VALUE',
272: to_char(forecast_interface(counter).inventory_item_id));
273: error_message := fnd_message.get;
274: set_interface_error(counter, forecast_interface, error_message);
275: -- IF mrdebug = TRUE THEN
276: -- dbms_output.put_line('Error for Item - '||
277: -- to_char(forecast_interface(counter).inventory_item_id));

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

291: forecast_interface(counter).organization_id;
292:
293: EXCEPTION
294: WHEN no_data_found THEN
295: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
296: fnd_message.set_token('ENTITY',
297: 'E_FORECAST_NAME', TRUE);
298: fnd_message.set_token('VALUE',
299: forecast_interface(counter).forecast_designator);

Line 296: fnd_message.set_token('ENTITY',

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

Line 298: fnd_message.set_token('VALUE',

294: WHEN no_data_found THEN
295: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
296: fnd_message.set_token('ENTITY',
297: 'E_FORECAST_NAME', TRUE);
298: fnd_message.set_token('VALUE',
299: forecast_interface(counter).forecast_designator);
300: error_message := fnd_message.get;
301: set_interface_error(counter, forecast_interface,
302: error_message);

Line 300: error_message := fnd_message.get;

296: fnd_message.set_token('ENTITY',
297: 'E_FORECAST_NAME', TRUE);
298: fnd_message.set_token('VALUE',
299: forecast_interface(counter).forecast_designator);
300: error_message := fnd_message.get;
301: set_interface_error(counter, forecast_interface,
302: error_message);
303: -- IF mrdebug = TRUE THEN
304: -- dbms_output.put_line('Error for Forecast name - '||

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

315: IF forecast_interface(counter).bucket_type <> 1 AND
316: forecast_interface(counter).bucket_type <> 2 AND
317: forecast_interface(counter).bucket_type <> 3
318: THEN
319: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
320: fnd_message.set_token('ENTITY', 'EC_BUCKET_TYPE', TRUE);
321: fnd_message.set_token('VALUE',
322: to_char(forecast_interface(counter).bucket_type));
323: error_message := fnd_message.get;

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

316: forecast_interface(counter).bucket_type <> 2 AND
317: forecast_interface(counter).bucket_type <> 3
318: THEN
319: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
320: fnd_message.set_token('ENTITY', 'EC_BUCKET_TYPE', TRUE);
321: fnd_message.set_token('VALUE',
322: to_char(forecast_interface(counter).bucket_type));
323: error_message := fnd_message.get;
324: set_interface_error(counter, forecast_interface, error_message);

Line 321: fnd_message.set_token('VALUE',

317: forecast_interface(counter).bucket_type <> 3
318: THEN
319: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
320: fnd_message.set_token('ENTITY', 'EC_BUCKET_TYPE', TRUE);
321: fnd_message.set_token('VALUE',
322: to_char(forecast_interface(counter).bucket_type));
323: error_message := fnd_message.get;
324: set_interface_error(counter, forecast_interface, error_message);
325: -- IF mrdebug = TRUE THEN

Line 323: error_message := fnd_message.get;

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

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

330: END IF;
331:
332: IF forecast_interface(counter).forecast_date is null
333: THEN
334: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
335: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
336: fnd_message.set_token('VALUE', 'NULL');
337: error_message := fnd_message.get;
338: set_interface_error(counter, forecast_interface, error_message);

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

331:
332: IF forecast_interface(counter).forecast_date is null
333: THEN
334: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
335: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
336: fnd_message.set_token('VALUE', 'NULL');
337: error_message := fnd_message.get;
338: set_interface_error(counter, forecast_interface, error_message);
339: -- IF mrdebug = TRUE THEN

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

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

Line 337: error_message := fnd_message.get;

333: THEN
334: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
335: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
336: fnd_message.set_token('VALUE', 'NULL');
337: error_message := fnd_message.get;
338: set_interface_error(counter, forecast_interface, error_message);
339: -- IF mrdebug = TRUE THEN
340: -- dbms_output.put_line('Error for Forecast date - NULL');
341: -- END IF;

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

347: forecast_interface(counter).bucket_type,
348: forecast_interface(counter).workday_control,
349: forecast_interface(counter).organization_id) = FALSE
350: THEN
351: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
352: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
353: fnd_message.set_token('VALUE',
354: to_char(forecast_interface(counter).forecast_date));
355: error_message := fnd_message.get;

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

348: forecast_interface(counter).workday_control,
349: forecast_interface(counter).organization_id) = FALSE
350: THEN
351: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
352: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
353: fnd_message.set_token('VALUE',
354: to_char(forecast_interface(counter).forecast_date));
355: error_message := fnd_message.get;
356: set_interface_error(counter, forecast_interface, error_message);

Line 353: fnd_message.set_token('VALUE',

349: forecast_interface(counter).organization_id) = FALSE
350: THEN
351: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
352: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
353: fnd_message.set_token('VALUE',
354: to_char(forecast_interface(counter).forecast_date));
355: error_message := fnd_message.get;
356: set_interface_error(counter, forecast_interface, error_message);
357: -- IF mrdebug = TRUE THEN

Line 355: error_message := fnd_message.get;

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

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

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

Line 372: error_message := fnd_message.get;

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

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

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

Line 382: error_message := fnd_message.get;

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

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

401: AND line_id = forecast_interface(counter).line_id;
402:
403: EXCEPTION
404: WHEN no_data_found THEN
405: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
406: fnd_message.set_token('ENTITY', 'E_LINE', TRUE);
407: fnd_message.set_token('VALUE',
408: to_char(forecast_interface(counter).line_id));
409: error_message := fnd_message.get;

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

402:
403: EXCEPTION
404: WHEN no_data_found THEN
405: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
406: fnd_message.set_token('ENTITY', 'E_LINE', TRUE);
407: fnd_message.set_token('VALUE',
408: to_char(forecast_interface(counter).line_id));
409: error_message := fnd_message.get;
410: set_interface_error(counter, forecast_interface, error_message);

Line 407: fnd_message.set_token('VALUE',

403: EXCEPTION
404: WHEN no_data_found THEN
405: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
406: fnd_message.set_token('ENTITY', 'E_LINE', TRUE);
407: fnd_message.set_token('VALUE',
408: to_char(forecast_interface(counter).line_id));
409: error_message := fnd_message.get;
410: set_interface_error(counter, forecast_interface, error_message);
411: -- IF mrdebug = TRUE THEN

Line 409: error_message := fnd_message.get;

405: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
406: fnd_message.set_token('ENTITY', 'E_LINE', TRUE);
407: fnd_message.set_token('VALUE',
408: to_char(forecast_interface(counter).line_id));
409: error_message := fnd_message.get;
410: set_interface_error(counter, forecast_interface, error_message);
411: -- IF mrdebug = TRUE THEN
412: -- dbms_output.put_line('Error for Line - '||
413: -- to_char(forecast_interface(counter).line_id));

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

429: );
430: END IF;
431:
432: IF (p_result = 'E') THEN
433: error_message := SUBSTRB(fnd_message.get,1,240);
434: set_interface_error(counter, forecast_interface, error_message);
435: goto skip_row;
436: END IF;
437:

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

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

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

747: IF adjust_date(p_start_date, l_new_start_date, 1, p_workday_control,
748: p_organization_id) = FALSE
749: THEN
750: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
751: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
752: fnd_message.set_token('VALUE', to_char(p_start_date));
753: fnd_msg_pub.add;
754: RAISE FND_API.G_EXC_ERROR;
755: END IF;

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

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

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

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

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

756: IF adjust_date(p_end_date, l_new_end_date, 1, p_workday_control,
757: p_organization_id) = FALSE
758: THEN
759: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
760: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
761: fnd_message.set_token('VALUE', to_char(p_end_date));
762: fnd_msg_pub.add;
763: RAISE FND_API.G_EXC_ERROR;
764: END IF;

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

757: p_organization_id) = FALSE
758: THEN
759: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
760: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
761: fnd_message.set_token('VALUE', to_char(p_end_date));
762: fnd_msg_pub.add;
763: RAISE FND_API.G_EXC_ERROR;
764: END IF;
765: