APPS.GMD_SUBSTITUTION_PUB dependencies on FND_MESSAGE

Line 67: FND_MESSAGE.SET_NAME('GMD','GMD_SUBS_CANNOT_UPD');

63:
64: IF ((l_status_code between 200 and 299) OR
65: (l_status_code >= 800) OR
66: (l_status_code between 500 and 599)) THEN
67: FND_MESSAGE.SET_NAME('GMD','GMD_SUBS_CANNOT_UPD');
68: FND_MSG_PUB.ADD;
69: Return FALSE;
70: END IF;
71:

Line 197: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

193:
194: /* Required fields at header level */
195: -- substitution_name and Substitution_version
196: IF l_substitution_hdr_rec.substitution_name IS NULL THEN
197: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
198: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_NAME');
199: FND_MSG_PUB.ADD;
200: RAISE substitution_creation_failure;
201: END IF;

Line 198: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_NAME');

194: /* Required fields at header level */
195: -- substitution_name and Substitution_version
196: IF l_substitution_hdr_rec.substitution_name IS NULL THEN
197: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
198: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_NAME');
199: FND_MSG_PUB.ADD;
200: RAISE substitution_creation_failure;
201: END IF;
202:

Line 204: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

200: RAISE substitution_creation_failure;
201: END IF;
202:
203: IF l_substitution_hdr_rec.substitution_version IS NULL THEN
204: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
205: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_VERSION');
206: FND_MSG_PUB.ADD;
207: RAISE substitution_creation_failure;
208: ELSIF (l_substitution_hdr_rec.substitution_version < 0 ) THEN

Line 205: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_VERSION');

201: END IF;
202:
203: IF l_substitution_hdr_rec.substitution_version IS NULL THEN
204: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
205: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_VERSION');
206: FND_MSG_PUB.ADD;
207: RAISE substitution_creation_failure;
208: ELSIF (l_substitution_hdr_rec.substitution_version < 0 ) THEN
209: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');

Line 209: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');

205: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_VERSION');
206: FND_MSG_PUB.ADD;
207: RAISE substitution_creation_failure;
208: ELSIF (l_substitution_hdr_rec.substitution_version < 0 ) THEN
209: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');
210: FND_MESSAGE.SET_TOKEN ('FIELD', 'SUBSTITUTION_VERSION');
211: FND_MSG_PUB.ADD;
212: RAISE substitution_creation_failure;
213: END IF;

Line 210: FND_MESSAGE.SET_TOKEN ('FIELD', 'SUBSTITUTION_VERSION');

206: FND_MSG_PUB.ADD;
207: RAISE substitution_creation_failure;
208: ELSIF (l_substitution_hdr_rec.substitution_version < 0 ) THEN
209: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');
210: FND_MESSAGE.SET_TOKEN ('FIELD', 'SUBSTITUTION_VERSION');
211: FND_MSG_PUB.ADD;
212: RAISE substitution_creation_failure;
213: END IF;
214:

Line 222: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

218: from dual;
219:
220: -- substitution_description
221: IF l_substitution_hdr_rec.substitution_description IS NULL THEN
222: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
223: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_DESCRIPTION');
224: FND_MSG_PUB.ADD;
225: RAISE substitution_creation_failure;
226: END IF;

Line 223: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_DESCRIPTION');

219:
220: -- substitution_description
221: IF l_substitution_hdr_rec.substitution_description IS NULL THEN
222: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
223: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_DESCRIPTION');
224: FND_MSG_PUB.ADD;
225: RAISE substitution_creation_failure;
226: END IF;
227:

Line 231: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

227:
228: -- original_item_id
229: IF ((l_substitution_hdr_rec.original_inventory_item_id IS NULL) AND
230: (l_substitution_hdr_rec.original_item_no IS NULL)) THEN
231: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
232: FND_MESSAGE.SET_TOKEN ('MISSING', 'ORIGINAL_ITEM_ID');
233: FND_MSG_PUB.ADD;
234: RAISE substitution_creation_failure;
235: ELSIF (l_substitution_hdr_rec.original_inventory_item_id IS NULL) THEN

Line 232: FND_MESSAGE.SET_TOKEN ('MISSING', 'ORIGINAL_ITEM_ID');

228: -- original_item_id
229: IF ((l_substitution_hdr_rec.original_inventory_item_id IS NULL) AND
230: (l_substitution_hdr_rec.original_item_no IS NULL)) THEN
231: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
232: FND_MESSAGE.SET_TOKEN ('MISSING', 'ORIGINAL_ITEM_ID');
233: FND_MSG_PUB.ADD;
234: RAISE substitution_creation_failure;
235: ELSIF (l_substitution_hdr_rec.original_inventory_item_id IS NULL) THEN
236: OPEN get_item_info2(l_substitution_hdr_rec.original_item_no);

Line 249: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INVALID_ORIGINAL_ITEM');

245: l_original_prim_item_um;
246: CLOSE get_item_info1;
247: END IF;
248: IF (l_original_prim_item_um IS NULL) THEN
249: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INVALID_ORIGINAL_ITEM');
250: FND_MESSAGE.SET_TOKEN('ORIGINAL_ITEM_NO', l_substitution_hdr_rec.original_item_no);
251: FND_MSG_PUB.ADD;
252: RAISE substitution_creation_failure;
253: END IF;

Line 250: FND_MESSAGE.SET_TOKEN('ORIGINAL_ITEM_NO', l_substitution_hdr_rec.original_item_no);

246: CLOSE get_item_info1;
247: END IF;
248: IF (l_original_prim_item_um IS NULL) THEN
249: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INVALID_ORIGINAL_ITEM');
250: FND_MESSAGE.SET_TOKEN('ORIGINAL_ITEM_NO', l_substitution_hdr_rec.original_item_no);
251: FND_MSG_PUB.ADD;
252: RAISE substitution_creation_failure;
253: END IF;
254:

Line 257: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

253: END IF;
254:
255: -- original_qty
256: IF l_substitution_hdr_rec.original_qty IS NULL THEN
257: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
258: FND_MESSAGE.SET_TOKEN ('MISSING', 'ORIGINAL_QTY');
259: FND_MSG_PUB.ADD;
260: RAISE substitution_creation_failure;
261: ELSIF (l_substitution_hdr_rec.original_qty < 0 ) THEN

Line 258: FND_MESSAGE.SET_TOKEN ('MISSING', 'ORIGINAL_QTY');

254:
255: -- original_qty
256: IF l_substitution_hdr_rec.original_qty IS NULL THEN
257: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
258: FND_MESSAGE.SET_TOKEN ('MISSING', 'ORIGINAL_QTY');
259: FND_MSG_PUB.ADD;
260: RAISE substitution_creation_failure;
261: ELSIF (l_substitution_hdr_rec.original_qty < 0 ) THEN
262: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');

Line 262: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');

258: FND_MESSAGE.SET_TOKEN ('MISSING', 'ORIGINAL_QTY');
259: FND_MSG_PUB.ADD;
260: RAISE substitution_creation_failure;
261: ELSIF (l_substitution_hdr_rec.original_qty < 0 ) THEN
262: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');
263: FND_MESSAGE.SET_TOKEN ('FIELD', 'ORIGINAL_QTY');
264: FND_MSG_PUB.ADD;
265: RAISE substitution_creation_failure;
266: END IF;

Line 263: FND_MESSAGE.SET_TOKEN ('FIELD', 'ORIGINAL_QTY');

259: FND_MSG_PUB.ADD;
260: RAISE substitution_creation_failure;
261: ELSIF (l_substitution_hdr_rec.original_qty < 0 ) THEN
262: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');
263: FND_MESSAGE.SET_TOKEN ('FIELD', 'ORIGINAL_QTY');
264: FND_MSG_PUB.ADD;
265: RAISE substitution_creation_failure;
266: END IF;
267:

Line 270: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

266: END IF;
267:
268: -- preference
269: IF l_substitution_hdr_rec.preference IS NULL THEN
270: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
271: FND_MESSAGE.SET_TOKEN ('MISSING', 'PREFERENCE');
272: FND_MSG_PUB.ADD;
273: RAISE substitution_creation_failure;
274: ELSIF (l_substitution_hdr_rec.preference < 0 ) THEN

Line 271: FND_MESSAGE.SET_TOKEN ('MISSING', 'PREFERENCE');

267:
268: -- preference
269: IF l_substitution_hdr_rec.preference IS NULL THEN
270: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
271: FND_MESSAGE.SET_TOKEN ('MISSING', 'PREFERENCE');
272: FND_MSG_PUB.ADD;
273: RAISE substitution_creation_failure;
274: ELSIF (l_substitution_hdr_rec.preference < 0 ) THEN
275: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');

Line 275: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');

271: FND_MESSAGE.SET_TOKEN ('MISSING', 'PREFERENCE');
272: FND_MSG_PUB.ADD;
273: RAISE substitution_creation_failure;
274: ELSIF (l_substitution_hdr_rec.preference < 0 ) THEN
275: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');
276: FND_MESSAGE.SET_TOKEN ('FIELD', 'PREFERENCE');
277: FND_MSG_PUB.ADD;
278: RAISE substitution_creation_failure;
279: END IF;

Line 276: FND_MESSAGE.SET_TOKEN ('FIELD', 'PREFERENCE');

272: FND_MSG_PUB.ADD;
273: RAISE substitution_creation_failure;
274: ELSIF (l_substitution_hdr_rec.preference < 0 ) THEN
275: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');
276: FND_MESSAGE.SET_TOKEN ('FIELD', 'PREFERENCE');
277: FND_MSG_PUB.ADD;
278: RAISE substitution_creation_failure;
279: END IF;
280:

Line 285: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');

281: -- replacement_uom_type -- Default it to value = 1 (original Item uom)
282: IF l_substitution_hdr_rec.replacement_uom_type IS NULL THEN
283: l_substitution_hdr_rec.replacement_uom_type := 1;
284: ELSIF (l_substitution_hdr_rec.replacement_uom_type < 0) THEN
285: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');
286: FND_MESSAGE.SET_TOKEN ('FIELD', 'REPLACEMENT_UOM_TYPE');
287: FND_MSG_PUB.ADD;
288: RAISE substitution_creation_failure;
289: ELSIF (l_substitution_hdr_rec.replacement_uom_type > 2) THEN

Line 286: FND_MESSAGE.SET_TOKEN ('FIELD', 'REPLACEMENT_UOM_TYPE');

282: IF l_substitution_hdr_rec.replacement_uom_type IS NULL THEN
283: l_substitution_hdr_rec.replacement_uom_type := 1;
284: ELSIF (l_substitution_hdr_rec.replacement_uom_type < 0) THEN
285: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');
286: FND_MESSAGE.SET_TOKEN ('FIELD', 'REPLACEMENT_UOM_TYPE');
287: FND_MSG_PUB.ADD;
288: RAISE substitution_creation_failure;
289: ELSIF (l_substitution_hdr_rec.replacement_uom_type > 2) THEN
290: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INV_REPLACEMENT_TYPE');

Line 290: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INV_REPLACEMENT_TYPE');

286: FND_MESSAGE.SET_TOKEN ('FIELD', 'REPLACEMENT_UOM_TYPE');
287: FND_MSG_PUB.ADD;
288: RAISE substitution_creation_failure;
289: ELSIF (l_substitution_hdr_rec.replacement_uom_type > 2) THEN
290: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INV_REPLACEMENT_TYPE');
291: FND_MSG_PUB.ADD;
292: RAISE substitution_creation_failure;
293: END IF;
294:

Line 297: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_ORGANIZATION_ID');

293: END IF;
294:
295: --Check that organization id is not null if raise an error message
296: IF (l_substitution_hdr_rec.owner_organization_id IS NULL) THEN
297: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_ORGANIZATION_ID');
298: FND_MSG_PUB.Add;
299: RAISE substitution_creation_failure;
300: ELSE
301: --Check the organization id passed is process enabled if not raise an error message

Line 303: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');

299: RAISE substitution_creation_failure;
300: ELSE
301: --Check the organization id passed is process enabled if not raise an error message
302: IF NOT (gmd_api_grp.check_orgn_status(l_substitution_hdr_rec.owner_organization_id)) THEN
303: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
304: FND_MESSAGE.SET_TOKEN('ORGN_ID', l_substitution_hdr_rec.owner_organization_id);
305: FND_MSG_PUB.Add;
306: RAISE substitution_creation_failure;
307: END IF;

Line 304: FND_MESSAGE.SET_TOKEN('ORGN_ID', l_substitution_hdr_rec.owner_organization_id);

300: ELSE
301: --Check the organization id passed is process enabled if not raise an error message
302: IF NOT (gmd_api_grp.check_orgn_status(l_substitution_hdr_rec.owner_organization_id)) THEN
303: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
304: FND_MESSAGE.SET_TOKEN('ORGN_ID', l_substitution_hdr_rec.owner_organization_id);
305: FND_MSG_PUB.Add;
306: RAISE substitution_creation_failure;
307: END IF;
308: OPEN get_item_orgn(l_substitution_hdr_rec.owner_organization_id);

Line 330: FND_MESSAGE.SET_NAME('GMD', 'GMD_ITSUB_UNIQUE_SUBS_VER');

326: FETCH get_substitution_id INTO l_dummy;
327: CLOSE get_substitution_id;
328:
329: IF (l_dummy > 0) THEN
330: FND_MESSAGE.SET_NAME('GMD', 'GMD_ITSUB_UNIQUE_SUBS_VER');
331: FND_MESSAGE.SET_TOKEN('SUBSNAM',l_substitution_hdr_rec.substitution_name);
332: FND_MESSAGE.SET_TOKEN('VERNAME',l_substitution_hdr_rec.substitution_version);
333: FND_MSG_PUB.ADD;
334: RAISE substitution_creation_failure;

Line 331: FND_MESSAGE.SET_TOKEN('SUBSNAM',l_substitution_hdr_rec.substitution_name);

327: CLOSE get_substitution_id;
328:
329: IF (l_dummy > 0) THEN
330: FND_MESSAGE.SET_NAME('GMD', 'GMD_ITSUB_UNIQUE_SUBS_VER');
331: FND_MESSAGE.SET_TOKEN('SUBSNAM',l_substitution_hdr_rec.substitution_name);
332: FND_MESSAGE.SET_TOKEN('VERNAME',l_substitution_hdr_rec.substitution_version);
333: FND_MSG_PUB.ADD;
334: RAISE substitution_creation_failure;
335: END IF;

Line 332: FND_MESSAGE.SET_TOKEN('VERNAME',l_substitution_hdr_rec.substitution_version);

328:
329: IF (l_dummy > 0) THEN
330: FND_MESSAGE.SET_NAME('GMD', 'GMD_ITSUB_UNIQUE_SUBS_VER');
331: FND_MESSAGE.SET_TOKEN('SUBSNAM',l_substitution_hdr_rec.substitution_name);
332: FND_MESSAGE.SET_TOKEN('VERNAME',l_substitution_hdr_rec.substitution_version);
333: FND_MSG_PUB.ADD;
334: RAISE substitution_creation_failure;
335: END IF;
336:

Line 349: FND_MESSAGE.SET_NAME('GMD','GMD_ITSUB_DATE_PRE_OVERLAP');

345: FETCH check_for_date_overlap INTO l_dummy;
346: CLOSE check_for_date_overlap;
347:
348: IF (l_dummy > 0) THEN
349: FND_MESSAGE.SET_NAME('GMD','GMD_ITSUB_DATE_PRE_OVERLAP');
350: FND_MSG_PUB.ADD;
351: RAISE substitution_creation_failure;
352: END IF;
353:

Line 359: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');

355: -- Start date should be less than End date
356: IF l_substitution_hdr_rec.end_date IS NOT NULL THEN
357: /* End date must be greater than start date, otherwise give error */
358: IF l_substitution_hdr_rec.end_date < l_substitution_hdr_rec.start_date THEN
359: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');
360: FND_MSG_PUB.ADD;
361: RAISE substitution_creation_failure;
362: END IF;
363: END IF;

Line 377: FND_MESSAGE.SET_NAME('GMD', 'GMD_ITEM_ORG_NOT_FOUND');

373: OPEN Cur_check_item(l_substitution_hdr_rec.owner_organization_id,
374: l_substitution_hdr_rec.Original_inventory_item_id);
375: FETCH Cur_check_item INTO l_ret;
376: IF L_RET IS NULL THEN
377: FND_MESSAGE.SET_NAME('GMD', 'GMD_ITEM_ORG_NOT_FOUND');
378: FND_MESSAGE.SET_TOKEN('ORGN',l_organization_code);
379: FND_MESSAGE.SET_TOKEN('ITEM',l_substitution_hdr_rec.original_item_no);
380: FND_MSG_PUB.ADD;
381: CLOSE cur_check_item;

Line 378: FND_MESSAGE.SET_TOKEN('ORGN',l_organization_code);

374: l_substitution_hdr_rec.Original_inventory_item_id);
375: FETCH Cur_check_item INTO l_ret;
376: IF L_RET IS NULL THEN
377: FND_MESSAGE.SET_NAME('GMD', 'GMD_ITEM_ORG_NOT_FOUND');
378: FND_MESSAGE.SET_TOKEN('ORGN',l_organization_code);
379: FND_MESSAGE.SET_TOKEN('ITEM',l_substitution_hdr_rec.original_item_no);
380: FND_MSG_PUB.ADD;
381: CLOSE cur_check_item;
382: RAISE substitution_creation_failure;

Line 379: FND_MESSAGE.SET_TOKEN('ITEM',l_substitution_hdr_rec.original_item_no);

375: FETCH Cur_check_item INTO l_ret;
376: IF L_RET IS NULL THEN
377: FND_MESSAGE.SET_NAME('GMD', 'GMD_ITEM_ORG_NOT_FOUND');
378: FND_MESSAGE.SET_TOKEN('ORGN',l_organization_code);
379: FND_MESSAGE.SET_TOKEN('ITEM',l_substitution_hdr_rec.original_item_no);
380: FND_MSG_PUB.ADD;
381: CLOSE cur_check_item;
382: RAISE substitution_creation_failure;
383: END IF;

Line 408: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

404:
405: -- substitute item_id
406: IF ((l_substitution_dtl_rec.inventory_item_id IS NULL) AND
407: (l_substitution_dtl_rec.item_no IS NULL)) THEN
408: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
409: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTE_ITEM_ID');
410: FND_MSG_PUB.ADD;
411: RAISE substitution_creation_failure;
412: ELSIF (l_substitution_dtl_rec.inventory_item_id IS NULL) THEN

Line 409: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTE_ITEM_ID');

405: -- substitute item_id
406: IF ((l_substitution_dtl_rec.inventory_item_id IS NULL) AND
407: (l_substitution_dtl_rec.item_no IS NULL)) THEN
408: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
409: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTE_ITEM_ID');
410: FND_MSG_PUB.ADD;
411: RAISE substitution_creation_failure;
412: ELSIF (l_substitution_dtl_rec.inventory_item_id IS NULL) THEN
413: OPEN get_item_info2(l_substitution_dtl_rec.item_no);

Line 427: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INVALID_SUBSTITUTE_ITEM');

423: CLOSE get_item_info1;
424: END IF;
425:
426: IF (l_substitute_prim_item_um IS NULL) THEN
427: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INVALID_SUBSTITUTE_ITEM');
428: FND_MESSAGE.SET_TOKEN('SUBSTITUTE_ITEM_NO',l_substitution_dtl_rec.item_no);
429: FND_MSG_PUB.ADD;
430: RAISE substitution_creation_failure;
431: END IF;

Line 428: FND_MESSAGE.SET_TOKEN('SUBSTITUTE_ITEM_NO',l_substitution_dtl_rec.item_no);

424: END IF;
425:
426: IF (l_substitute_prim_item_um IS NULL) THEN
427: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INVALID_SUBSTITUTE_ITEM');
428: FND_MESSAGE.SET_TOKEN('SUBSTITUTE_ITEM_NO',l_substitution_dtl_rec.item_no);
429: FND_MSG_PUB.ADD;
430: RAISE substitution_creation_failure;
431: END IF;
432:

Line 435: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

431: END IF;
432:
433: -- unit_qty
434: IF l_substitution_dtl_rec.unit_qty IS NULL THEN
435: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
436: FND_MESSAGE.SET_TOKEN ('MISSING', 'UNIT_QTY');
437: FND_MSG_PUB.ADD;
438: RAISE substitution_creation_failure;
439: ELSIF (l_substitution_dtl_rec.unit_qty < 0 ) THEN

Line 436: FND_MESSAGE.SET_TOKEN ('MISSING', 'UNIT_QTY');

432:
433: -- unit_qty
434: IF l_substitution_dtl_rec.unit_qty IS NULL THEN
435: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
436: FND_MESSAGE.SET_TOKEN ('MISSING', 'UNIT_QTY');
437: FND_MSG_PUB.ADD;
438: RAISE substitution_creation_failure;
439: ELSIF (l_substitution_dtl_rec.unit_qty < 0 ) THEN
440: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');

Line 440: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');

436: FND_MESSAGE.SET_TOKEN ('MISSING', 'UNIT_QTY');
437: FND_MSG_PUB.ADD;
438: RAISE substitution_creation_failure;
439: ELSIF (l_substitution_dtl_rec.unit_qty < 0 ) THEN
440: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');
441: FND_MESSAGE.SET_TOKEN ('FIELD', 'UNIT_QTY');
442: FND_MSG_PUB.ADD;
443: RAISE substitution_creation_failure;
444: END IF;

Line 441: FND_MESSAGE.SET_TOKEN ('FIELD', 'UNIT_QTY');

437: FND_MSG_PUB.ADD;
438: RAISE substitution_creation_failure;
439: ELSIF (l_substitution_dtl_rec.unit_qty < 0 ) THEN
440: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');
441: FND_MESSAGE.SET_TOKEN ('FIELD', 'UNIT_QTY');
442: FND_MSG_PUB.ADD;
443: RAISE substitution_creation_failure;
444: END IF;
445:

Line 451: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');

447: IF l_substitution_dtl_rec.detail_uom IS NULL THEN
448: l_substitution_dtl_rec.detail_uom := l_substitute_prim_item_um;
449: ELSE
450: IF (NOT(gma_valid_grp.validate_um(l_substitution_dtl_rec.detail_uom))) THEN
451: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
452: FND_MSG_PUB.ADD;
453: RAISE substitution_creation_failure;
454: END IF;
455: END IF;

Line 476: FND_MESSAGE.SET_NAME('GMD','FM_SCALE_BAD_ITEM_UOM');

472: ,to_unit => l_substitute_prim_item_um
473: ,from_name => NULL
474: ,to_name => NULL);
475: IF l_dummy < 0 THEN
476: FND_MESSAGE.SET_NAME('GMD','FM_SCALE_BAD_ITEM_UOM');
477: FND_MESSAGE.SET_TOKEN('FROM_UOM', l_substitution_dtl_rec.detail_uom);
478: FND_MESSAGE.SET_TOKEN('TO_UOM', l_substitute_prim_item_um);
479: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_substitution_dtl_rec.item_no);
480: FND_MSG_PUB.ADD;

Line 477: FND_MESSAGE.SET_TOKEN('FROM_UOM', l_substitution_dtl_rec.detail_uom);

473: ,from_name => NULL
474: ,to_name => NULL);
475: IF l_dummy < 0 THEN
476: FND_MESSAGE.SET_NAME('GMD','FM_SCALE_BAD_ITEM_UOM');
477: FND_MESSAGE.SET_TOKEN('FROM_UOM', l_substitution_dtl_rec.detail_uom);
478: FND_MESSAGE.SET_TOKEN('TO_UOM', l_substitute_prim_item_um);
479: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_substitution_dtl_rec.item_no);
480: FND_MSG_PUB.ADD;
481: RAISE substitution_creation_failure;

Line 478: FND_MESSAGE.SET_TOKEN('TO_UOM', l_substitute_prim_item_um);

474: ,to_name => NULL);
475: IF l_dummy < 0 THEN
476: FND_MESSAGE.SET_NAME('GMD','FM_SCALE_BAD_ITEM_UOM');
477: FND_MESSAGE.SET_TOKEN('FROM_UOM', l_substitution_dtl_rec.detail_uom);
478: FND_MESSAGE.SET_TOKEN('TO_UOM', l_substitute_prim_item_um);
479: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_substitution_dtl_rec.item_no);
480: FND_MSG_PUB.ADD;
481: RAISE substitution_creation_failure;
482: END IF;

Line 479: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_substitution_dtl_rec.item_no);

475: IF l_dummy < 0 THEN
476: FND_MESSAGE.SET_NAME('GMD','FM_SCALE_BAD_ITEM_UOM');
477: FND_MESSAGE.SET_TOKEN('FROM_UOM', l_substitution_dtl_rec.detail_uom);
478: FND_MESSAGE.SET_TOKEN('TO_UOM', l_substitute_prim_item_um);
479: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_substitution_dtl_rec.item_no);
480: FND_MSG_PUB.ADD;
481: RAISE substitution_creation_failure;
482: END IF;
483:

Line 494: FND_MESSAGE.SET_NAME('GMD','FM_SCALE_BAD_ITEM_UOM');

490: ,to_unit => l_original_prim_item_um
491: ,from_name => NULL
492: ,to_name => NULL);
493: IF l_dummy < 0 THEN
494: FND_MESSAGE.SET_NAME('GMD','FM_SCALE_BAD_ITEM_UOM');
495: FND_MESSAGE.SET_TOKEN('FROM_UOM', l_substitution_dtl_rec.detail_uom);
496: FND_MESSAGE.SET_TOKEN('TO_UOM', l_original_prim_item_um);
497: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_substitution_dtl_rec.item_no);
498: FND_MSG_PUB.ADD;

Line 495: FND_MESSAGE.SET_TOKEN('FROM_UOM', l_substitution_dtl_rec.detail_uom);

491: ,from_name => NULL
492: ,to_name => NULL);
493: IF l_dummy < 0 THEN
494: FND_MESSAGE.SET_NAME('GMD','FM_SCALE_BAD_ITEM_UOM');
495: FND_MESSAGE.SET_TOKEN('FROM_UOM', l_substitution_dtl_rec.detail_uom);
496: FND_MESSAGE.SET_TOKEN('TO_UOM', l_original_prim_item_um);
497: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_substitution_dtl_rec.item_no);
498: FND_MSG_PUB.ADD;
499: RAISE substitution_creation_failure;

Line 496: FND_MESSAGE.SET_TOKEN('TO_UOM', l_original_prim_item_um);

492: ,to_name => NULL);
493: IF l_dummy < 0 THEN
494: FND_MESSAGE.SET_NAME('GMD','FM_SCALE_BAD_ITEM_UOM');
495: FND_MESSAGE.SET_TOKEN('FROM_UOM', l_substitution_dtl_rec.detail_uom);
496: FND_MESSAGE.SET_TOKEN('TO_UOM', l_original_prim_item_um);
497: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_substitution_dtl_rec.item_no);
498: FND_MSG_PUB.ADD;
499: RAISE substitution_creation_failure;
500: END IF;

Line 497: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_substitution_dtl_rec.item_no);

493: IF l_dummy < 0 THEN
494: FND_MESSAGE.SET_NAME('GMD','FM_SCALE_BAD_ITEM_UOM');
495: FND_MESSAGE.SET_TOKEN('FROM_UOM', l_substitution_dtl_rec.detail_uom);
496: FND_MESSAGE.SET_TOKEN('TO_UOM', l_original_prim_item_um);
497: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_substitution_dtl_rec.item_no);
498: FND_MSG_PUB.ADD;
499: RAISE substitution_creation_failure;
500: END IF;
501: END IF;

Line 510: FND_MESSAGE.SET_NAME('GMD', 'GMD_ITEM_ORG_NOT_FOUND');

506: OPEN Cur_check_item(l_substitution_hdr_rec.owner_organization_id,
507: l_substitution_dtl_rec.inventory_item_id);
508: FETCH Cur_check_item INTO l_ret;
509: IF L_RET IS NULL THEN
510: FND_MESSAGE.SET_NAME('GMD', 'GMD_ITEM_ORG_NOT_FOUND');
511: FND_MESSAGE.SET_TOKEN('ORGN',l_organization_code);
512: FND_MESSAGE.SET_TOKEN('ITEM',l_substitution_dtl_rec.item_no);
513: FND_MSG_PUB.ADD;
514: CLOSE cur_check_item;

Line 511: FND_MESSAGE.SET_TOKEN('ORGN',l_organization_code);

507: l_substitution_dtl_rec.inventory_item_id);
508: FETCH Cur_check_item INTO l_ret;
509: IF L_RET IS NULL THEN
510: FND_MESSAGE.SET_NAME('GMD', 'GMD_ITEM_ORG_NOT_FOUND');
511: FND_MESSAGE.SET_TOKEN('ORGN',l_organization_code);
512: FND_MESSAGE.SET_TOKEN('ITEM',l_substitution_dtl_rec.item_no);
513: FND_MSG_PUB.ADD;
514: CLOSE cur_check_item;
515: RAISE substitution_creation_failure;

Line 512: FND_MESSAGE.SET_TOKEN('ITEM',l_substitution_dtl_rec.item_no);

508: FETCH Cur_check_item INTO l_ret;
509: IF L_RET IS NULL THEN
510: FND_MESSAGE.SET_NAME('GMD', 'GMD_ITEM_ORG_NOT_FOUND');
511: FND_MESSAGE.SET_TOKEN('ORGN',l_organization_code);
512: FND_MESSAGE.SET_TOKEN('ITEM',l_substitution_dtl_rec.item_no);
513: FND_MSG_PUB.ADD;
514: CLOSE cur_check_item;
515: RAISE substitution_creation_failure;
516: END IF;

Line 541: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

537: -- formula_id or formula_no/formule_vers combination
538: IF (l_formula_substitution_rec.formula_id IS NULL) AND
539: (l_formula_substitution_rec.formula_no IS NULL OR
540: l_formula_substitution_rec.formula_vers IS NULL) THEN
541: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
542: FND_MESSAGE.SET_TOKEN ('MISSING', 'FORMULA_ID');
543: FND_MSG_PUB.ADD;
544: RAISE substitution_creation_failure;
545: ELSIF (l_formula_substitution_rec.formula_id IS NULL) THEN

Line 542: FND_MESSAGE.SET_TOKEN ('MISSING', 'FORMULA_ID');

538: IF (l_formula_substitution_rec.formula_id IS NULL) AND
539: (l_formula_substitution_rec.formula_no IS NULL OR
540: l_formula_substitution_rec.formula_vers IS NULL) THEN
541: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
542: FND_MESSAGE.SET_TOKEN ('MISSING', 'FORMULA_ID');
543: FND_MSG_PUB.ADD;
544: RAISE substitution_creation_failure;
545: ELSIF (l_formula_substitution_rec.formula_id IS NULL) THEN
546: -- Get the formula id

Line 553: FND_MESSAGE.SET_NAME ('GMD', 'QC_INVALID_FORMULA');

549: ,pversion => l_formula_substitution_rec.formula_vers
550: ,xvalue => l_formula_substitution_rec.formula_id
551: ,xreturn_code => l_dummy);
552: IF (l_dummy < 0) THEN
553: FND_MESSAGE.SET_NAME ('GMD', 'QC_INVALID_FORMULA');
554: FND_MSG_PUB.ADD;
555: RAISE substitution_creation_failure;
556: END IF;
557: ELSE

Line 571: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INACTIVE_FMSUB');

567: FETCH validate_formula INTO l_dummy;
568: CLOSE validate_formula;
569:
570: IF (l_dummy <> 1) THEN
571: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INACTIVE_FMSUB');
572: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',l_formula_substitution_rec.formula_vers);
573: FND_MESSAGE.SET_TOKEN('FORMULA_NO',l_formula_substitution_rec.formula_no);
574: FND_MSG_PUB.ADD;
575: RAISE substitution_creation_failure;

Line 572: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',l_formula_substitution_rec.formula_vers);

568: CLOSE validate_formula;
569:
570: IF (l_dummy <> 1) THEN
571: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INACTIVE_FMSUB');
572: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',l_formula_substitution_rec.formula_vers);
573: FND_MESSAGE.SET_TOKEN('FORMULA_NO',l_formula_substitution_rec.formula_no);
574: FND_MSG_PUB.ADD;
575: RAISE substitution_creation_failure;
576: END IF;

Line 573: FND_MESSAGE.SET_TOKEN('FORMULA_NO',l_formula_substitution_rec.formula_no);

569:
570: IF (l_dummy <> 1) THEN
571: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INACTIVE_FMSUB');
572: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',l_formula_substitution_rec.formula_vers);
573: FND_MESSAGE.SET_TOKEN('FORMULA_NO',l_formula_substitution_rec.formula_no);
574: FND_MSG_PUB.ADD;
575: RAISE substitution_creation_failure;
576: END IF;
577: -- reset l_dummy

Line 590: FND_MESSAGE.SET_NAME ('GMD', 'GMD_FMSUB_INGR_MISSING');

586: FETCH validate_formula_item INTO l_dummy;
587: CLOSE validate_formula_item;
588:
589: IF (l_dummy <> 1) THEN
590: FND_MESSAGE.SET_NAME ('GMD', 'GMD_FMSUB_INGR_MISSING');
591: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',l_formula_substitution_rec.formula_vers);
592: FND_MESSAGE.SET_TOKEN('FORMULA_NO',l_formula_substitution_rec.formula_no);
593: FND_MSG_PUB.ADD;
594: RAISE substitution_creation_failure;

Line 591: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',l_formula_substitution_rec.formula_vers);

587: CLOSE validate_formula_item;
588:
589: IF (l_dummy <> 1) THEN
590: FND_MESSAGE.SET_NAME ('GMD', 'GMD_FMSUB_INGR_MISSING');
591: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',l_formula_substitution_rec.formula_vers);
592: FND_MESSAGE.SET_TOKEN('FORMULA_NO',l_formula_substitution_rec.formula_no);
593: FND_MSG_PUB.ADD;
594: RAISE substitution_creation_failure;
595: END IF;

Line 592: FND_MESSAGE.SET_TOKEN('FORMULA_NO',l_formula_substitution_rec.formula_no);

588:
589: IF (l_dummy <> 1) THEN
590: FND_MESSAGE.SET_NAME ('GMD', 'GMD_FMSUB_INGR_MISSING');
591: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',l_formula_substitution_rec.formula_vers);
592: FND_MESSAGE.SET_TOKEN('FORMULA_NO',l_formula_substitution_rec.formula_no);
593: FND_MSG_PUB.ADD;
594: RAISE substitution_creation_failure;
595: END IF;
596: -- reset l_dummy

Line 729: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

725: -- Substitution id or (substitution_name and Substitution_version)
726: IF ((p_substitution_id IS NULL) AND
727: (p_substitution_name IS NULL OR
728: p_substitution_version IS NULL)) THEN
729: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
730: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_ID');
731: FND_MSG_PUB.ADD;
732: RAISE substitution_creation_failure;
733: ELSIF (p_substitution_id IS NULL) THEN

Line 730: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_ID');

726: IF ((p_substitution_id IS NULL) AND
727: (p_substitution_name IS NULL OR
728: p_substitution_version IS NULL)) THEN
729: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
730: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_ID');
731: FND_MSG_PUB.ADD;
732: RAISE substitution_creation_failure;
733: ELSIF (p_substitution_id IS NULL) THEN
734: -- Get the subsitution id

Line 740: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INVALID_SUBSTITUTION');

736: ,p_substitution_version);
737: FETCH get_substitution_id INTO l_substitution_id;
738: IF (get_substitution_id%NOTFOUND) THEN
739: CLOSE get_substitution_id;
740: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INVALID_SUBSTITUTION');
741: FND_MSG_PUB.ADD;
742: RAISE substitution_creation_failure;
743: END IF;
744: CLOSE get_substitution_id;

Line 762: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

758: -- formula_id or (formula_no and formula_version combination
759: IF ((l_formula_substitution_rec.formula_id IS NULL) AND
760: (l_formula_substitution_rec.formula_no IS NULL OR
761: l_formula_substitution_rec.formula_vers IS NULL)) THEN
762: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
763: FND_MESSAGE.SET_TOKEN ('MISSING', 'FORMULA_ID');
764: FND_MSG_PUB.ADD;
765: RAISE substitution_creation_failure;
766: ELSIF (l_formula_substitution_rec.formula_id IS NULL) THEN

Line 763: FND_MESSAGE.SET_TOKEN ('MISSING', 'FORMULA_ID');

759: IF ((l_formula_substitution_rec.formula_id IS NULL) AND
760: (l_formula_substitution_rec.formula_no IS NULL OR
761: l_formula_substitution_rec.formula_vers IS NULL)) THEN
762: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
763: FND_MESSAGE.SET_TOKEN ('MISSING', 'FORMULA_ID');
764: FND_MSG_PUB.ADD;
765: RAISE substitution_creation_failure;
766: ELSIF (l_formula_substitution_rec.formula_id IS NULL) THEN
767: -- Get the formula id

Line 774: FND_MESSAGE.SET_NAME ('GMD', 'QC_INVALID_FORMULA');

770: ,pversion => l_formula_substitution_rec.formula_vers
771: ,xvalue => l_formula_substitution_rec.formula_id
772: ,xreturn_code => l_dummy);
773: IF (l_dummy < 0) THEN
774: FND_MESSAGE.SET_NAME ('GMD', 'QC_INVALID_FORMULA');
775: FND_MSG_PUB.ADD;
776: RAISE substitution_creation_failure;
777: END IF;
778: -- reset

Line 787: FND_MESSAGE.SET_NAME ('GMD', 'QC_INVALID_FORMULA');

783: FETCH get_formula_no_vers INTO l_formula_substitution_rec.formula_no,
784: l_formula_substitution_rec.formula_vers;
785: IF (get_formula_no_vers%NOTFOUND) THEN
786: CLOSE get_formula_no_vers;
787: FND_MESSAGE.SET_NAME ('GMD', 'QC_INVALID_FORMULA');
788: FND_MSG_PUB.ADD;
789: RAISE substitution_creation_failure;
790: END IF;
791: CLOSE get_formula_no_vers;

Line 806: FND_MESSAGE.SET_NAME ('GMD', 'GMD_FMSUB_INGR_MISSING');

802: FETCH validate_formula_item INTO l_dummy;
803: CLOSE validate_formula_item;
804:
805: IF (l_dummy <> 1) THEN
806: FND_MESSAGE.SET_NAME ('GMD', 'GMD_FMSUB_INGR_MISSING');
807: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',l_formula_substitution_rec.formula_vers);
808: FND_MESSAGE.SET_TOKEN('FORMULA_NO',l_formula_substitution_rec.formula_no);
809: FND_MSG_PUB.ADD;
810: RAISE substitution_creation_failure;

Line 807: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',l_formula_substitution_rec.formula_vers);

803: CLOSE validate_formula_item;
804:
805: IF (l_dummy <> 1) THEN
806: FND_MESSAGE.SET_NAME ('GMD', 'GMD_FMSUB_INGR_MISSING');
807: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',l_formula_substitution_rec.formula_vers);
808: FND_MESSAGE.SET_TOKEN('FORMULA_NO',l_formula_substitution_rec.formula_no);
809: FND_MSG_PUB.ADD;
810: RAISE substitution_creation_failure;
811: END IF;

Line 808: FND_MESSAGE.SET_TOKEN('FORMULA_NO',l_formula_substitution_rec.formula_no);

804:
805: IF (l_dummy <> 1) THEN
806: FND_MESSAGE.SET_NAME ('GMD', 'GMD_FMSUB_INGR_MISSING');
807: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',l_formula_substitution_rec.formula_vers);
808: FND_MESSAGE.SET_TOKEN('FORMULA_NO',l_formula_substitution_rec.formula_no);
809: FND_MSG_PUB.ADD;
810: RAISE substitution_creation_failure;
811: END IF;
812: -- reset l_dummy

Line 821: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INACTIVE_FMSUB');

817: FETCH validate_formula INTO l_dummy;
818: CLOSE validate_formula;
819:
820: IF (l_dummy <> 1) THEN
821: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INACTIVE_FMSUB');
822: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',l_formula_substitution_rec.formula_vers);
823: FND_MESSAGE.SET_TOKEN('FORMULA_NO',l_formula_substitution_rec.formula_no);
824: FND_MSG_PUB.ADD;
825: RAISE substitution_creation_failure;

Line 822: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',l_formula_substitution_rec.formula_vers);

818: CLOSE validate_formula;
819:
820: IF (l_dummy <> 1) THEN
821: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INACTIVE_FMSUB');
822: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',l_formula_substitution_rec.formula_vers);
823: FND_MESSAGE.SET_TOKEN('FORMULA_NO',l_formula_substitution_rec.formula_no);
824: FND_MSG_PUB.ADD;
825: RAISE substitution_creation_failure;
826: END IF;

Line 823: FND_MESSAGE.SET_TOKEN('FORMULA_NO',l_formula_substitution_rec.formula_no);

819:
820: IF (l_dummy <> 1) THEN
821: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INACTIVE_FMSUB');
822: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',l_formula_substitution_rec.formula_vers);
823: FND_MESSAGE.SET_TOKEN('FORMULA_NO',l_formula_substitution_rec.formula_no);
824: FND_MSG_PUB.ADD;
825: RAISE substitution_creation_failure;
826: END IF;
827: -- reset l_dummy

Line 838: FND_MESSAGE.SET_NAME ('GMD', 'GMD_FMSUB_ASSN_EXISTS');

834: FETCH validate_formula_substitution INTO l_dummy;
835: CLOSE validate_formula_substitution;
836:
837: IF (l_dummy = 1) THEN
838: FND_MESSAGE.SET_NAME ('GMD', 'GMD_FMSUB_ASSN_EXISTS');
839: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',l_formula_substitution_rec.formula_vers);
840: FND_MESSAGE.SET_TOKEN('FORMULA_NO',l_formula_substitution_rec.formula_no);
841: FND_MSG_PUB.ADD;
842: RAISE substitution_creation_failure;

Line 839: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',l_formula_substitution_rec.formula_vers);

835: CLOSE validate_formula_substitution;
836:
837: IF (l_dummy = 1) THEN
838: FND_MESSAGE.SET_NAME ('GMD', 'GMD_FMSUB_ASSN_EXISTS');
839: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',l_formula_substitution_rec.formula_vers);
840: FND_MESSAGE.SET_TOKEN('FORMULA_NO',l_formula_substitution_rec.formula_no);
841: FND_MSG_PUB.ADD;
842: RAISE substitution_creation_failure;
843: END IF;

Line 840: FND_MESSAGE.SET_TOKEN('FORMULA_NO',l_formula_substitution_rec.formula_no);

836:
837: IF (l_dummy = 1) THEN
838: FND_MESSAGE.SET_NAME ('GMD', 'GMD_FMSUB_ASSN_EXISTS');
839: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',l_formula_substitution_rec.formula_vers);
840: FND_MESSAGE.SET_TOKEN('FORMULA_NO',l_formula_substitution_rec.formula_no);
841: FND_MSG_PUB.ADD;
842: RAISE substitution_creation_failure;
843: END IF;
844:

Line 966: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

962: -- Substitution id or (substitution_name and Substitution_version)
963: IF (p_substitution_id IS NULL) THEN
964: IF (p_substitution_name IS NULL) OR (p_substitution_version IS NULL) THEN
965: -- Raise a exception
966: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
967: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_ID');
968: FND_MSG_PUB.ADD;
969: RAISE substitution_update_failure;
970: ELSE

Line 967: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_ID');

963: IF (p_substitution_id IS NULL) THEN
964: IF (p_substitution_name IS NULL) OR (p_substitution_version IS NULL) THEN
965: -- Raise a exception
966: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
967: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_ID');
968: FND_MSG_PUB.ADD;
969: RAISE substitution_update_failure;
970: ELSE
971: OPEN get_substitution_id(p_substitution_name, p_substitution_version);

Line 975: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INVALID_SUBSTITUTION');

971: OPEN get_substitution_id(p_substitution_name, p_substitution_version);
972: FETCH get_substitution_id INTO l_substitution_id;
973: IF (get_substitution_id%NOTFOUND) THEN
974: CLOSE get_substitution_id;
975: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INVALID_SUBSTITUTION');
976: FND_MSG_PUB.ADD;
977: RAISE substitution_update_failure;
978: END IF;
979: CLOSE get_substitution_id;

Line 995: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INVALID_SUBSTITUTION');

991: OPEN get_old_substitution_rec(l_substitution_id);
992: FETCH get_old_substitution_rec INTO l_substitution_hdr_rec;
993: IF (get_old_substitution_rec%NOTFOUND) THEN
994: CLOSE get_old_substitution_rec;
995: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INVALID_SUBSTITUTION');
996: FND_MSG_PUB.ADD;
997: RAISE substitution_update_failure;
998: END IF;
999: CLOSE get_old_substitution_rec;

Line 1010: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');

1006: l_substitution_hdr_rec.start_date :=
1007: FND_DATE.canonical_to_date(p_update_table(i).p_value);
1008: IF (l_substitution_hdr_rec.end_date IS NOT NULL) THEN
1009: IF (l_substitution_hdr_rec.end_date < l_substitution_hdr_rec.start_date) THEN
1010: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');
1011: FND_MSG_PUB.ADD;
1012: RAISE substitution_update_failure;
1013: END IF;
1014: END IF;

Line 1019: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');

1015: ELSIF (Upper(p_update_table(i).p_col_to_update) = 'SUBSTITUTION_DESCRIPTION') THEN
1016: l_substitution_hdr_rec.substitution_description := p_update_table(i).p_value;
1017: ELSIF (Upper(p_update_table(i).p_col_to_update) = 'PREFERENCE') THEN
1018: IF (p_update_table(i).p_value < 0 ) THEN
1019: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');
1020: FND_MESSAGE.SET_TOKEN ('FIELD', 'PREFERENCE');
1021: FND_MSG_PUB.ADD;
1022: RAISE substitution_update_failure;
1023: END IF;

Line 1020: FND_MESSAGE.SET_TOKEN ('FIELD', 'PREFERENCE');

1016: l_substitution_hdr_rec.substitution_description := p_update_table(i).p_value;
1017: ELSIF (Upper(p_update_table(i).p_col_to_update) = 'PREFERENCE') THEN
1018: IF (p_update_table(i).p_value < 0 ) THEN
1019: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');
1020: FND_MESSAGE.SET_TOKEN ('FIELD', 'PREFERENCE');
1021: FND_MSG_PUB.ADD;
1022: RAISE substitution_update_failure;
1023: END IF;
1024: l_substitution_hdr_rec.preference := p_update_table(i).p_value;

Line 1030: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');

1026: l_substitution_hdr_rec.end_date :=
1027: FND_DATE.canonical_to_date(p_update_table(i).p_value);
1028: IF (p_update_table(i).p_value IS NOT NULL) THEN
1029: IF (l_substitution_hdr_rec.start_date > l_substitution_hdr_rec.end_date) THEN
1030: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');
1031: FND_MSG_PUB.ADD;
1032: RAISE substitution_update_failure;
1033: END IF;
1034: END IF;

Line 1037: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');

1033: END IF;
1034: END IF;
1035: ELSIF (Upper(p_update_table(i).p_col_to_update) = 'ORIGINAL_QTY') THEN
1036: IF (p_update_table(i).p_value < 0) THEN
1037: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');
1038: FND_MESSAGE.SET_TOKEN ('FIELD', 'ORIGINAL_QTY');
1039: FND_MSG_PUB.ADD;
1040: RAISE substitution_update_failure;
1041: END IF;

Line 1038: FND_MESSAGE.SET_TOKEN ('FIELD', 'ORIGINAL_QTY');

1034: END IF;
1035: ELSIF (Upper(p_update_table(i).p_col_to_update) = 'ORIGINAL_QTY') THEN
1036: IF (p_update_table(i).p_value < 0) THEN
1037: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');
1038: FND_MESSAGE.SET_TOKEN ('FIELD', 'ORIGINAL_QTY');
1039: FND_MSG_PUB.ADD;
1040: RAISE substitution_update_failure;
1041: END IF;
1042: l_substitution_hdr_rec.original_qty := p_update_table(i).p_value;

Line 1046: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');

1042: l_substitution_hdr_rec.original_qty := p_update_table(i).p_value;
1043: ELSIF (Upper(p_update_table(i).p_col_to_update) = 'REPLACEMENT_UOM_TYPE') THEN
1044: -- replacement_uom_type -- Default it to value = 1 (original Item uom)
1045: IF (p_update_table(i).p_value < 0) THEN
1046: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');
1047: FND_MESSAGE.SET_TOKEN ('FIELD', 'REPLACEMENT_UOM_TYPE');
1048: FND_MSG_PUB.ADD;
1049: RAISE substitution_update_failure;
1050: ELSIF (p_update_table(i).p_value > 2) THEN

Line 1047: FND_MESSAGE.SET_TOKEN ('FIELD', 'REPLACEMENT_UOM_TYPE');

1043: ELSIF (Upper(p_update_table(i).p_col_to_update) = 'REPLACEMENT_UOM_TYPE') THEN
1044: -- replacement_uom_type -- Default it to value = 1 (original Item uom)
1045: IF (p_update_table(i).p_value < 0) THEN
1046: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');
1047: FND_MESSAGE.SET_TOKEN ('FIELD', 'REPLACEMENT_UOM_TYPE');
1048: FND_MSG_PUB.ADD;
1049: RAISE substitution_update_failure;
1050: ELSIF (p_update_table(i).p_value > 2) THEN
1051: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INV_REPLACEMENT_TYPE');

Line 1051: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INV_REPLACEMENT_TYPE');

1047: FND_MESSAGE.SET_TOKEN ('FIELD', 'REPLACEMENT_UOM_TYPE');
1048: FND_MSG_PUB.ADD;
1049: RAISE substitution_update_failure;
1050: ELSIF (p_update_table(i).p_value > 2) THEN
1051: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INV_REPLACEMENT_TYPE');
1052: FND_MSG_PUB.ADD;
1053: RAISE substitution_update_failure;
1054: END IF;
1055: l_substitution_hdr_rec.replacement_uom_type := p_update_table(i).p_value;

Line 1063: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COL_UPDATES');

1059: ELSIF (Upper(p_update_table(i).p_col_to_update) IN
1060: ('ORIGINAL_UOM'
1061: ,'OWNER_ORGANIZATION_ID'
1062: ,'ORIGINAL_INVENTORY_ITEM_ID')) THEN
1063: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COL_UPDATES');
1064: FND_MESSAGE.SET_TOKEN('NAME',p_update_table(i).p_col_to_update);
1065: FND_MSG_PUB.ADD;
1066: RAISE substitution_update_failure;
1067: ELSIF (Upper(p_update_table(i).p_col_to_update) =

Line 1064: FND_MESSAGE.SET_TOKEN('NAME',p_update_table(i).p_col_to_update);

1060: ('ORIGINAL_UOM'
1061: ,'OWNER_ORGANIZATION_ID'
1062: ,'ORIGINAL_INVENTORY_ITEM_ID')) THEN
1063: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COL_UPDATES');
1064: FND_MESSAGE.SET_TOKEN('NAME',p_update_table(i).p_col_to_update);
1065: FND_MSG_PUB.ADD;
1066: RAISE substitution_update_failure;
1067: ELSIF (Upper(p_update_table(i).p_col_to_update) =
1068: ('SUBSTITUTION_STATUS')) THEN

Line 1069: FND_MESSAGE.SET_NAME('GMD', 'GMD_NOT_USE_API_UPD_STATUS');

1065: FND_MSG_PUB.ADD;
1066: RAISE substitution_update_failure;
1067: ELSIF (Upper(p_update_table(i).p_col_to_update) =
1068: ('SUBSTITUTION_STATUS')) THEN
1069: FND_MESSAGE.SET_NAME('GMD', 'GMD_NOT_USE_API_UPD_STATUS');
1070: FND_MSG_PUB.ADD;
1071: RAISE substitution_update_failure;
1072: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'ATTRIBUTE1') THEN
1073: l_substitution_hdr_rec.ATTRIBUTE1 := p_update_table(i).p_value;

Line 1135: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_UPDCOL_NAME');

1131: l_substitution_hdr_rec.ATTRIBUTE30 := p_update_table(i).p_value;
1132: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'ATTRIBUTE_CATEGORY') THEN
1133: l_substitution_hdr_rec.ATTRIBUTE_CATEGORY := p_update_table(i).p_value;
1134: ELSE
1135: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_UPDCOL_NAME');
1136: FND_MESSAGE.SET_TOKEN('NAME', p_update_table(i).p_col_to_update);
1137: FND_MSG_PUB.ADD;
1138: RAISE substitution_update_failure;
1139: END IF;

Line 1136: FND_MESSAGE.SET_TOKEN('NAME', p_update_table(i).p_col_to_update);

1132: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'ATTRIBUTE_CATEGORY') THEN
1133: l_substitution_hdr_rec.ATTRIBUTE_CATEGORY := p_update_table(i).p_value;
1134: ELSE
1135: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_UPDCOL_NAME');
1136: FND_MESSAGE.SET_TOKEN('NAME', p_update_table(i).p_col_to_update);
1137: FND_MSG_PUB.ADD;
1138: RAISE substitution_update_failure;
1139: END IF;
1140:

Line 1276: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

1272: -- Substitution id or (substitution_name and Substitution_version)
1273: IF (p_substitution_id IS NULL) THEN
1274: IF (p_substitution_name IS NULL) OR (p_substitution_version IS NULL) THEN
1275: -- Raise a exception
1276: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1277: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_ID');
1278: FND_MSG_PUB.ADD;
1279: RAISE substitution_update_failure;
1280: ELSE

Line 1277: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_ID');

1273: IF (p_substitution_id IS NULL) THEN
1274: IF (p_substitution_name IS NULL) OR (p_substitution_version IS NULL) THEN
1275: -- Raise a exception
1276: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1277: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_ID');
1278: FND_MSG_PUB.ADD;
1279: RAISE substitution_update_failure;
1280: ELSE
1281: OPEN get_substitution_id(p_substitution_name, p_substitution_version);

Line 1286: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INVALID_SUBSTITUTION');

1282: FETCH get_substitution_id INTO l_substitution_id;
1283: IF (get_substitution_id%NOTFOUND) THEN
1284: CLOSE get_substitution_id;
1285: -- raise no record found exception
1286: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INVALID_SUBSTITUTION');
1287: FND_MSG_PUB.ADD;
1288: RAISE substitution_update_failure;
1289: END IF;
1290: CLOSE get_substitution_id;

Line 1309: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INVALID_SUBSTITUTION');

1305: FETCH get_subsdtl_rec_using_hdr_id INTO l_substitution_dtl_rec;
1306: CLOSE get_subsdtl_rec_using_hdr_id;
1307: ELSE
1308: -- raise no record found exception
1309: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INVALID_SUBSTITUTION');
1310: FND_MSG_PUB.ADD;
1311: RAISE substitution_update_failure;
1312: END IF;
1313:

Line 1325: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');

1321: -- to the original item uom.
1322: IF UPPER(p_update_table(i).p_col_to_update) = 'DETAIL_UOM' THEN
1323: IF p_update_table(i).p_value IS NOT NULL THEN
1324: IF (NOT(gma_valid_grp.validate_um(p_update_table(i).p_value))) THEN
1325: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
1326: FND_MSG_PUB.ADD;
1327: RAISE substitution_update_failure;
1328: END IF;
1329: END IF;

Line 1355: FND_MESSAGE.SET_NAME('GMD','FM_SCALE_BAD_ITEM_UOM');

1351: ,to_unit => l_substitute_prim_item_um
1352: ,from_name => NULL
1353: ,to_name => NULL);
1354: IF l_dummy < 0 THEN
1355: FND_MESSAGE.SET_NAME('GMD','FM_SCALE_BAD_ITEM_UOM');
1356: FND_MESSAGE.SET_TOKEN('FROM_UOM', p_update_table(i).p_value);
1357: FND_MESSAGE.SET_TOKEN('TO_UOM', l_substitute_prim_item_um);
1358: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_substitute_item_no);
1359: FND_MSG_PUB.ADD;

Line 1356: FND_MESSAGE.SET_TOKEN('FROM_UOM', p_update_table(i).p_value);

1352: ,from_name => NULL
1353: ,to_name => NULL);
1354: IF l_dummy < 0 THEN
1355: FND_MESSAGE.SET_NAME('GMD','FM_SCALE_BAD_ITEM_UOM');
1356: FND_MESSAGE.SET_TOKEN('FROM_UOM', p_update_table(i).p_value);
1357: FND_MESSAGE.SET_TOKEN('TO_UOM', l_substitute_prim_item_um);
1358: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_substitute_item_no);
1359: FND_MSG_PUB.ADD;
1360: RAISE substitution_update_failure;

Line 1357: FND_MESSAGE.SET_TOKEN('TO_UOM', l_substitute_prim_item_um);

1353: ,to_name => NULL);
1354: IF l_dummy < 0 THEN
1355: FND_MESSAGE.SET_NAME('GMD','FM_SCALE_BAD_ITEM_UOM');
1356: FND_MESSAGE.SET_TOKEN('FROM_UOM', p_update_table(i).p_value);
1357: FND_MESSAGE.SET_TOKEN('TO_UOM', l_substitute_prim_item_um);
1358: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_substitute_item_no);
1359: FND_MSG_PUB.ADD;
1360: RAISE substitution_update_failure;
1361: END IF;

Line 1358: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_substitute_item_no);

1354: IF l_dummy < 0 THEN
1355: FND_MESSAGE.SET_NAME('GMD','FM_SCALE_BAD_ITEM_UOM');
1356: FND_MESSAGE.SET_TOKEN('FROM_UOM', p_update_table(i).p_value);
1357: FND_MESSAGE.SET_TOKEN('TO_UOM', l_substitute_prim_item_um);
1358: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_substitute_item_no);
1359: FND_MSG_PUB.ADD;
1360: RAISE substitution_update_failure;
1361: END IF;
1362: -- reset l_dummy

Line 1375: FND_MESSAGE.SET_NAME('GMD','FM_SCALE_BAD_ITEM_UOM');

1371: ,to_unit => l_original_prim_item_um
1372: ,from_name => NULL
1373: ,to_name => NULL);
1374: IF l_dummy < 0 THEN
1375: FND_MESSAGE.SET_NAME('GMD','FM_SCALE_BAD_ITEM_UOM');
1376: FND_MESSAGE.SET_TOKEN('FROM_UOM', p_update_table(i).p_value);
1377: FND_MESSAGE.SET_TOKEN('TO_UOM', l_original_prim_item_um);
1378: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_substitute_item_no);
1379: FND_MSG_PUB.ADD;

Line 1376: FND_MESSAGE.SET_TOKEN('FROM_UOM', p_update_table(i).p_value);

1372: ,from_name => NULL
1373: ,to_name => NULL);
1374: IF l_dummy < 0 THEN
1375: FND_MESSAGE.SET_NAME('GMD','FM_SCALE_BAD_ITEM_UOM');
1376: FND_MESSAGE.SET_TOKEN('FROM_UOM', p_update_table(i).p_value);
1377: FND_MESSAGE.SET_TOKEN('TO_UOM', l_original_prim_item_um);
1378: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_substitute_item_no);
1379: FND_MSG_PUB.ADD;
1380: RAISE substitution_update_failure;

Line 1377: FND_MESSAGE.SET_TOKEN('TO_UOM', l_original_prim_item_um);

1373: ,to_name => NULL);
1374: IF l_dummy < 0 THEN
1375: FND_MESSAGE.SET_NAME('GMD','FM_SCALE_BAD_ITEM_UOM');
1376: FND_MESSAGE.SET_TOKEN('FROM_UOM', p_update_table(i).p_value);
1377: FND_MESSAGE.SET_TOKEN('TO_UOM', l_original_prim_item_um);
1378: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_substitute_item_no);
1379: FND_MSG_PUB.ADD;
1380: RAISE substitution_update_failure;
1381: END IF;

Line 1378: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_substitute_item_no);

1374: IF l_dummy < 0 THEN
1375: FND_MESSAGE.SET_NAME('GMD','FM_SCALE_BAD_ITEM_UOM');
1376: FND_MESSAGE.SET_TOKEN('FROM_UOM', p_update_table(i).p_value);
1377: FND_MESSAGE.SET_TOKEN('TO_UOM', l_original_prim_item_um);
1378: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_substitute_item_no);
1379: FND_MSG_PUB.ADD;
1380: RAISE substitution_update_failure;
1381: END IF;
1382: END IF;

Line 1390: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

1386: l_substitution_dtl_rec.detail_uom := p_update_table(i).p_value;
1387:
1388: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'UNIT_QTY' THEN
1389: IF p_update_table(i).p_value IS NULL THEN
1390: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1391: FND_MESSAGE.SET_TOKEN ('MISSING', 'UNIT_QTY');
1392: FND_MSG_PUB.ADD;
1393: RAISE substitution_update_failure;
1394: ELSIF (p_update_table(i).p_value < 0 ) THEN

Line 1391: FND_MESSAGE.SET_TOKEN ('MISSING', 'UNIT_QTY');

1387:
1388: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'UNIT_QTY' THEN
1389: IF p_update_table(i).p_value IS NULL THEN
1390: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1391: FND_MESSAGE.SET_TOKEN ('MISSING', 'UNIT_QTY');
1392: FND_MSG_PUB.ADD;
1393: RAISE substitution_update_failure;
1394: ELSIF (p_update_table(i).p_value < 0 ) THEN
1395: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');

Line 1395: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');

1391: FND_MESSAGE.SET_TOKEN ('MISSING', 'UNIT_QTY');
1392: FND_MSG_PUB.ADD;
1393: RAISE substitution_update_failure;
1394: ELSIF (p_update_table(i).p_value < 0 ) THEN
1395: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');
1396: FND_MESSAGE.SET_TOKEN ('FIELD', 'UNIT_QTY');
1397: FND_MSG_PUB.ADD;
1398: RAISE substitution_update_failure;
1399: END IF;

Line 1396: FND_MESSAGE.SET_TOKEN ('FIELD', 'UNIT_QTY');

1392: FND_MSG_PUB.ADD;
1393: RAISE substitution_update_failure;
1394: ELSIF (p_update_table(i).p_value < 0 ) THEN
1395: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');
1396: FND_MESSAGE.SET_TOKEN ('FIELD', 'UNIT_QTY');
1397: FND_MSG_PUB.ADD;
1398: RAISE substitution_update_failure;
1399: END IF;
1400: l_substitution_dtl_rec.unit_qty := p_update_table(i).p_value;

Line 1404: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COL_UPDATES');

1400: l_substitution_dtl_rec.unit_qty := p_update_table(i).p_value;
1401: -- Cannot change the Substitute item for the list
1402: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'INVENTORY_ITEM_ID' THEN
1403: -- raise exception
1404: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COL_UPDATES');
1405: FND_MESSAGE.SET_TOKEN('NAME',p_update_table(i).p_col_to_update);
1406: FND_MSG_PUB.ADD;
1407: RAISE substitution_update_failure;
1408: ELSE

Line 1405: FND_MESSAGE.SET_TOKEN('NAME',p_update_table(i).p_col_to_update);

1401: -- Cannot change the Substitute item for the list
1402: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'INVENTORY_ITEM_ID' THEN
1403: -- raise exception
1404: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COL_UPDATES');
1405: FND_MESSAGE.SET_TOKEN('NAME',p_update_table(i).p_col_to_update);
1406: FND_MSG_PUB.ADD;
1407: RAISE substitution_update_failure;
1408: ELSE
1409: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_UPDCOL_NAME');

Line 1409: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_UPDCOL_NAME');

1405: FND_MESSAGE.SET_TOKEN('NAME',p_update_table(i).p_col_to_update);
1406: FND_MSG_PUB.ADD;
1407: RAISE substitution_update_failure;
1408: ELSE
1409: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_UPDCOL_NAME');
1410: FND_MESSAGE.SET_TOKEN('NAME', p_update_table(i).p_col_to_update);
1411: FND_MSG_PUB.ADD;
1412: RAISE substitution_update_failure;
1413: END IF;

Line 1410: FND_MESSAGE.SET_TOKEN('NAME', p_update_table(i).p_col_to_update);

1406: FND_MSG_PUB.ADD;
1407: RAISE substitution_update_failure;
1408: ELSE
1409: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_UPDCOL_NAME');
1410: FND_MESSAGE.SET_TOKEN('NAME', p_update_table(i).p_col_to_update);
1411: FND_MSG_PUB.ADD;
1412: RAISE substitution_update_failure;
1413: END IF;
1414:

Line 1537: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

1533: -- Substitution id or (substitution_name and Substitution_version)
1534: IF ((p_substitution_id IS NULL) AND
1535: (p_substitution_name IS NULL OR
1536: p_substitution_version IS NULL)) THEN
1537: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1538: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_ID');
1539: FND_MSG_PUB.ADD;
1540: RAISE substitution_delete_failure;
1541: ELSIF (p_substitution_id IS NULL) THEN

Line 1538: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_ID');

1534: IF ((p_substitution_id IS NULL) AND
1535: (p_substitution_name IS NULL OR
1536: p_substitution_version IS NULL)) THEN
1537: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1538: FND_MESSAGE.SET_TOKEN ('MISSING', 'SUBSTITUTION_ID');
1539: FND_MSG_PUB.ADD;
1540: RAISE substitution_delete_failure;
1541: ELSIF (p_substitution_id IS NULL) THEN
1542: -- Get the subsitution id

Line 1548: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INVALID_SUBSTITUTION');

1544: ,p_substitution_version);
1545: FETCH get_substitution_id INTO l_substitution_id;
1546: IF (get_substitution_id%NOTFOUND) THEN
1547: CLOSE get_substitution_id;
1548: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INVALID_SUBSTITUTION');
1549: FND_MSG_PUB.ADD;
1550: RAISE substitution_delete_failure;
1551: END IF;
1552: CLOSE get_substitution_id;

Line 1560: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

1556:
1557: -- formula_id or (formula_no and formula_version combination
1558: IF ((p_formula_id IS NULL) AND
1559: (p_formula_no IS NULL OR p_formula_vers IS NULL)) THEN
1560: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1561: FND_MESSAGE.SET_TOKEN ('MISSING', 'FORMULA_ID');
1562: FND_MSG_PUB.ADD;
1563: RAISE substitution_delete_failure;
1564: ELSIF (p_formula_id IS NULL) THEN

Line 1561: FND_MESSAGE.SET_TOKEN ('MISSING', 'FORMULA_ID');

1557: -- formula_id or (formula_no and formula_version combination
1558: IF ((p_formula_id IS NULL) AND
1559: (p_formula_no IS NULL OR p_formula_vers IS NULL)) THEN
1560: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1561: FND_MESSAGE.SET_TOKEN ('MISSING', 'FORMULA_ID');
1562: FND_MSG_PUB.ADD;
1563: RAISE substitution_delete_failure;
1564: ELSIF (p_formula_id IS NULL) THEN
1565: -- Get the formula id

Line 1572: FND_MESSAGE.SET_NAME ('GMD', 'QC_INVALID_FORMULA');

1568: ,pversion => p_formula_vers
1569: ,xvalue => l_formula_id
1570: ,xreturn_code => l_dummy);
1571: IF (l_dummy < 0) THEN
1572: FND_MESSAGE.SET_NAME ('GMD', 'QC_INVALID_FORMULA');
1573: FND_MSG_PUB.ADD;
1574: RAISE substitution_delete_failure;
1575: END IF;
1576: ELSE

Line 1585: FND_MESSAGE.SET_NAME ('GMD', 'GMD_FMSUB_ASSN_MISSING');

1581: OPEN get_formula_substitution_id(l_substitution_id, l_formula_id);
1582: FETCH get_formula_substitution_id INTO l_formula_substitution_id;
1583: IF (get_formula_substitution_id%NOTFOUND) THEN
1584: CLOSE get_formula_substitution_id;
1585: FND_MESSAGE.SET_NAME ('GMD', 'GMD_FMSUB_ASSN_MISSING');
1586: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',p_formula_vers);
1587: FND_MESSAGE.SET_TOKEN('FORMULA_NO',p_formula_no);
1588: FND_MSG_PUB.ADD;
1589: RAISE substitution_delete_failure;

Line 1586: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',p_formula_vers);

1582: FETCH get_formula_substitution_id INTO l_formula_substitution_id;
1583: IF (get_formula_substitution_id%NOTFOUND) THEN
1584: CLOSE get_formula_substitution_id;
1585: FND_MESSAGE.SET_NAME ('GMD', 'GMD_FMSUB_ASSN_MISSING');
1586: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',p_formula_vers);
1587: FND_MESSAGE.SET_TOKEN('FORMULA_NO',p_formula_no);
1588: FND_MSG_PUB.ADD;
1589: RAISE substitution_delete_failure;
1590: END IF;

Line 1587: FND_MESSAGE.SET_TOKEN('FORMULA_NO',p_formula_no);

1583: IF (get_formula_substitution_id%NOTFOUND) THEN
1584: CLOSE get_formula_substitution_id;
1585: FND_MESSAGE.SET_NAME ('GMD', 'GMD_FMSUB_ASSN_MISSING');
1586: FND_MESSAGE.SET_TOKEN('FORMULA_VERSION',p_formula_vers);
1587: FND_MESSAGE.SET_TOKEN('FORMULA_NO',p_formula_no);
1588: FND_MSG_PUB.ADD;
1589: RAISE substitution_delete_failure;
1590: END IF;
1591: CLOSE get_formula_substitution_id;

Line 1598: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

1594: FETCH get_formula_subs_info INTO l_substitution_id;
1595: CLOSE get_formula_subs_info;
1596:
1597: IF (l_substitution_id IS NULL) THEN
1598: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1599: FND_MESSAGE.SET_TOKEN ('MISSING', 'FORMULA_SUBSTITUTION_ID');
1600: FND_MSG_PUB.ADD;
1601: RAISE substitution_delete_failure;
1602: ELSE

Line 1599: FND_MESSAGE.SET_TOKEN ('MISSING', 'FORMULA_SUBSTITUTION_ID');

1595: CLOSE get_formula_subs_info;
1596:
1597: IF (l_substitution_id IS NULL) THEN
1598: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1599: FND_MESSAGE.SET_TOKEN ('MISSING', 'FORMULA_SUBSTITUTION_ID');
1600: FND_MSG_PUB.ADD;
1601: RAISE substitution_delete_failure;
1602: ELSE
1603: l_formula_substitution_id := p_formula_Substitution_id;