DBA Data[Home] [Help]

APPS.GMIVLOT dependencies on FND_MESSAGE

Line 283: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');

279: /* further validation. */
280: IF p_ic_item_mst_row.item_id = 0 OR
281: p_ic_item_mst_row.delete_mark = 1
282: THEN
283: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
284: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_ic_item_mst_row.item_no);
285: FND_MSG_PUB.Add;
286: RAISE FND_API.G_EXC_ERROR;
287: ELSIF p_ic_item_mst_row.inactive_ind = 1 AND

Line 284: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_ic_item_mst_row.item_no);

280: IF p_ic_item_mst_row.item_id = 0 OR
281: p_ic_item_mst_row.delete_mark = 1
282: THEN
283: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
284: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_ic_item_mst_row.item_no);
285: FND_MSG_PUB.Add;
286: RAISE FND_API.G_EXC_ERROR;
287: ELSIF p_ic_item_mst_row.inactive_ind = 1 AND
288: GMIGUTL.IC$API_ALLOW_INACTIVE = 0

Line 290: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');

286: RAISE FND_API.G_EXC_ERROR;
287: ELSIF p_ic_item_mst_row.inactive_ind = 1 AND
288: GMIGUTL.IC$API_ALLOW_INACTIVE = 0
289: THEN
290: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');
291: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_ic_item_mst_row.item_no);
292: FND_MSG_PUB.Add;
293: RAISE FND_API.G_EXC_ERROR;
294: END IF;

Line 291: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_ic_item_mst_row.item_no);

287: ELSIF p_ic_item_mst_row.inactive_ind = 1 AND
288: GMIGUTL.IC$API_ALLOW_INACTIVE = 0
289: THEN
290: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');
291: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_ic_item_mst_row.item_no);
292: FND_MSG_PUB.Add;
293: RAISE FND_API.G_EXC_ERROR;
294: END IF;
295:

Line 301: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_NOT_LOT_CTL');

297:
298: /* Check to see if item is lot Controlled */
299: IF p_ic_item_mst_row.lot_ctl = 0
300: THEN
301: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_NOT_LOT_CTL');
302: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
303: FND_MSG_PUB.Add;
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: END IF;

Line 302: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);

298: /* Check to see if item is lot Controlled */
299: IF p_ic_item_mst_row.lot_ctl = 0
300: THEN
301: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_NOT_LOT_CTL');
302: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
303: FND_MSG_PUB.Add;
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: END IF;
306:

Line 313: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');

309: THEN
310: /* J. DiIorio 01/19/2001 BUG#1570046 */
311: x_ic_lots_mst_row.lot_no := UPPER(p_lot_rec.lot_no);
312: ELSE
313: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
314: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
315: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
316: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
317: FND_MSG_PUB.Add;

Line 314: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);

310: /* J. DiIorio 01/19/2001 BUG#1570046 */
311: x_ic_lots_mst_row.lot_no := UPPER(p_lot_rec.lot_no);
312: ELSE
313: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
314: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
315: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
316: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
317: FND_MSG_PUB.Add;
318: x_return_status := FND_API.G_RET_STS_ERROR;

Line 315: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);

311: x_ic_lots_mst_row.lot_no := UPPER(p_lot_rec.lot_no);
312: ELSE
313: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
314: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
315: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
316: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
317: FND_MSG_PUB.Add;
318: x_return_status := FND_API.G_RET_STS_ERROR;
319: END IF;

Line 316: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);

312: ELSE
313: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
314: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
315: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
316: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
317: FND_MSG_PUB.Add;
318: x_return_status := FND_API.G_RET_STS_ERROR;
319: END IF;
320:

Line 350: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_QC_GRADE');

346: IF GMIGUTL.v_qc_grade(UPPER(p_lot_rec.qc_grade),l_qc_grad_mst_row)
347: THEN
348: x_ic_lots_mst_row.qc_grade := l_qc_grad_mst_row.qc_grade;
349: ELSE
350: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_QC_GRADE');
351: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
352: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
353: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
354: FND_MSG_PUB.Add;

Line 351: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

347: THEN
348: x_ic_lots_mst_row.qc_grade := l_qc_grad_mst_row.qc_grade;
349: ELSE
350: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_QC_GRADE');
351: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
352: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
353: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
354: FND_MSG_PUB.Add;
355: x_return_status := FND_API.G_RET_STS_ERROR;

Line 352: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);

348: x_ic_lots_mst_row.qc_grade := l_qc_grad_mst_row.qc_grade;
349: ELSE
350: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_QC_GRADE');
351: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
352: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
353: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
354: FND_MSG_PUB.Add;
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: END IF;

Line 353: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);

349: ELSE
350: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_QC_GRADE');
351: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
352: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
353: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
354: FND_MSG_PUB.Add;
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: END IF;
357: END IF;

Line 370: FND_MESSAGE.SET_NAME('GMI','IC_API_INV_LOT_EXPACTION_CODE');

366: (UPPER(p_lot_rec.expaction_code), l_qc_actn_mst_row)
367: THEN
368: x_ic_lots_mst_row.expaction_code:=l_qc_actn_mst_row.action_code;
369: ELSE
370: FND_MESSAGE.SET_NAME('GMI','IC_API_INV_LOT_EXPACTION_CODE');
371: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
372: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
373: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
374: FND_MSG_PUB.Add;

Line 371: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);

367: THEN
368: x_ic_lots_mst_row.expaction_code:=l_qc_actn_mst_row.action_code;
369: ELSE
370: FND_MESSAGE.SET_NAME('GMI','IC_API_INV_LOT_EXPACTION_CODE');
371: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
372: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
373: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
374: FND_MSG_PUB.Add;
375: x_return_status := FND_API.G_RET_STS_ERROR;

Line 372: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);

368: x_ic_lots_mst_row.expaction_code:=l_qc_actn_mst_row.action_code;
369: ELSE
370: FND_MESSAGE.SET_NAME('GMI','IC_API_INV_LOT_EXPACTION_CODE');
371: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
372: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
373: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
374: FND_MSG_PUB.Add;
375: x_return_status := FND_API.G_RET_STS_ERROR;
376: END IF;

Line 373: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);

369: ELSE
370: FND_MESSAGE.SET_NAME('GMI','IC_API_INV_LOT_EXPACTION_CODE');
371: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
372: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
373: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
374: FND_MSG_PUB.Add;
375: x_return_status := FND_API.G_RET_STS_ERROR;
376: END IF;
377: END IF;

Line 401: FND_MESSAGE.SET_NAME('GMI','IC_API_PAST_EXPIRE_DATE');

397: -- Modified code so that user is now allowed to create expired lots.
398: -- However a message is logged.
399: x_ic_lots_mst_row.expire_date := p_lot_rec.expire_date;
400: IF TRUNC(p_lot_rec.expire_date) < TRUNC(x_ic_lots_mst_row.lot_created) THEN
401: FND_MESSAGE.SET_NAME('GMI','IC_API_PAST_EXPIRE_DATE');
402: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
403: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
404: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
405: FND_MSG_PUB.Add;

Line 402: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);

398: -- However a message is logged.
399: x_ic_lots_mst_row.expire_date := p_lot_rec.expire_date;
400: IF TRUNC(p_lot_rec.expire_date) < TRUNC(x_ic_lots_mst_row.lot_created) THEN
401: FND_MESSAGE.SET_NAME('GMI','IC_API_PAST_EXPIRE_DATE');
402: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
403: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
404: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
405: FND_MSG_PUB.Add;
406: END IF;

Line 403: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);

399: x_ic_lots_mst_row.expire_date := p_lot_rec.expire_date;
400: IF TRUNC(p_lot_rec.expire_date) < TRUNC(x_ic_lots_mst_row.lot_created) THEN
401: FND_MESSAGE.SET_NAME('GMI','IC_API_PAST_EXPIRE_DATE');
402: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
403: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
404: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
405: FND_MSG_PUB.Add;
406: END IF;
407: -- END BUG#3115930

Line 404: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);

400: IF TRUNC(p_lot_rec.expire_date) < TRUNC(x_ic_lots_mst_row.lot_created) THEN
401: FND_MESSAGE.SET_NAME('GMI','IC_API_PAST_EXPIRE_DATE');
402: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
403: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
404: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
405: FND_MSG_PUB.Add;
406: END IF;
407: -- END BUG#3115930
408: END IF;

Line 433: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_RETEST_DATE');

429: IF TRUNC(p_lot_rec.retest_date) >= TRUNC(x_ic_lots_mst_row.lot_created)
430: THEN
431: x_ic_lots_mst_row.retest_date := p_lot_rec.retest_date;
432: ELSE
433: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_RETEST_DATE');
434: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
435: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
436: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
437: FND_MSG_PUB.Add;

Line 434: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);

430: THEN
431: x_ic_lots_mst_row.retest_date := p_lot_rec.retest_date;
432: ELSE
433: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_RETEST_DATE');
434: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
435: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
436: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
437: FND_MSG_PUB.Add;
438: x_return_status := FND_API.G_RET_STS_ERROR;

Line 435: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);

431: x_ic_lots_mst_row.retest_date := p_lot_rec.retest_date;
432: ELSE
433: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_RETEST_DATE');
434: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
435: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
436: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
437: FND_MSG_PUB.Add;
438: x_return_status := FND_API.G_RET_STS_ERROR;
439: END IF;

Line 436: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);

432: ELSE
433: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_RETEST_DATE');
434: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
435: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
436: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
437: FND_MSG_PUB.Add;
438: x_return_status := FND_API.G_RET_STS_ERROR;
439: END IF;
440: END IF;

Line 465: FND_MESSAGE.SET_NAME('GMI','IC_API_PAST_EXPACTION_DATE');

461: -- Modified code so that user is now allowed to create expired lots.
462: -- However a message is logged.
463: x_ic_lots_mst_row.expaction_date := p_lot_rec.expaction_date;
464: IF TRUNC(p_lot_rec.expaction_date) < TRUNC(x_ic_lots_mst_row.lot_created) THEN
465: FND_MESSAGE.SET_NAME('GMI','IC_API_PAST_EXPACTION_DATE');
466: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
467: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
468: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
469: FND_MSG_PUB.Add;

Line 466: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);

462: -- However a message is logged.
463: x_ic_lots_mst_row.expaction_date := p_lot_rec.expaction_date;
464: IF TRUNC(p_lot_rec.expaction_date) < TRUNC(x_ic_lots_mst_row.lot_created) THEN
465: FND_MESSAGE.SET_NAME('GMI','IC_API_PAST_EXPACTION_DATE');
466: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
467: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
468: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
469: FND_MSG_PUB.Add;
470: END IF;

Line 467: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);

463: x_ic_lots_mst_row.expaction_date := p_lot_rec.expaction_date;
464: IF TRUNC(p_lot_rec.expaction_date) < TRUNC(x_ic_lots_mst_row.lot_created) THEN
465: FND_MESSAGE.SET_NAME('GMI','IC_API_PAST_EXPACTION_DATE');
466: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
467: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
468: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
469: FND_MSG_PUB.Add;
470: END IF;
471: -- END BUG#3115930

Line 468: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);

464: IF TRUNC(p_lot_rec.expaction_date) < TRUNC(x_ic_lots_mst_row.lot_created) THEN
465: FND_MESSAGE.SET_NAME('GMI','IC_API_PAST_EXPACTION_DATE');
466: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
467: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
468: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
469: FND_MSG_PUB.Add;
470: END IF;
471: -- END BUG#3115930
472: END IF;

Line 479: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_STRENGTH');

475: IF p_lot_rec.strength BETWEEN 0 AND 100
476: THEN
477: x_ic_lots_mst_row.strength := p_lot_rec.strength;
478: ELSE
479: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_STRENGTH');
480: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
481: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
482: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
483: FND_MSG_PUB.Add;

Line 480: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);

476: THEN
477: x_ic_lots_mst_row.strength := p_lot_rec.strength;
478: ELSE
479: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_STRENGTH');
480: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
481: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
482: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
483: FND_MSG_PUB.Add;
484: x_return_status := FND_API.G_RET_STS_ERROR;

Line 481: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);

477: x_ic_lots_mst_row.strength := p_lot_rec.strength;
478: ELSE
479: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_STRENGTH');
480: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
481: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
482: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
483: FND_MSG_PUB.Add;
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: END IF;

Line 482: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);

478: ELSE
479: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_STRENGTH');
480: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
481: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
482: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
483: FND_MSG_PUB.Add;
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: END IF;
486:

Line 492: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_INACTIVE');

488: IF p_lot_rec.inactive_ind IN (0,1)
489: THEN
490: x_ic_lots_mst_row.inactive_ind := p_lot_rec.inactive_ind;
491: ELSE
492: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_INACTIVE');
493: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
494: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
495: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
496: FND_MSG_PUB.Add;

Line 493: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);

489: THEN
490: x_ic_lots_mst_row.inactive_ind := p_lot_rec.inactive_ind;
491: ELSE
492: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_INACTIVE');
493: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
494: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
495: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
496: FND_MSG_PUB.Add;
497: x_return_status := FND_API.G_RET_STS_ERROR;

Line 494: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);

490: x_ic_lots_mst_row.inactive_ind := p_lot_rec.inactive_ind;
491: ELSE
492: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_INACTIVE');
493: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
494: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
495: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
496: FND_MSG_PUB.Add;
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: END IF;

Line 495: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);

491: ELSE
492: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_INACTIVE');
493: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
494: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
495: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
496: FND_MSG_PUB.Add;
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: END IF;
499:

Line 506: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_ORIG_TYPE');

502: IF p_lot_rec.origination_type IN (0,1,2,3)
503: THEN
504: x_ic_lots_mst_row.origination_type := p_lot_rec.origination_type;
505: ELSE
506: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_ORIG_TYPE');
507: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
508: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
509: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
510: FND_MSG_PUB.Add;

Line 507: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);

503: THEN
504: x_ic_lots_mst_row.origination_type := p_lot_rec.origination_type;
505: ELSE
506: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_ORIG_TYPE');
507: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
508: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
509: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
510: FND_MSG_PUB.Add;
511: x_return_status := FND_API.G_RET_STS_ERROR;

Line 508: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);

504: x_ic_lots_mst_row.origination_type := p_lot_rec.origination_type;
505: ELSE
506: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_ORIG_TYPE');
507: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
508: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
509: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
510: FND_MSG_PUB.Add;
511: x_return_status := FND_API.G_RET_STS_ERROR;
512: END IF;

Line 509: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);

505: ELSE
506: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_ORIG_TYPE');
507: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
508: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
509: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
510: FND_MSG_PUB.Add;
511: x_return_status := FND_API.G_RET_STS_ERROR;
512: END IF;
513:

Line 523: FND_MESSAGE.SET_NAME('GMI','IC_API_INV_LOT_SHIPVENDOR_NO');

519: IF GMIGUTL.v_ship_vendor(p_lot_rec.shipvendor_no,l_po_vend_mst_row)
520: THEN
521: x_ic_lots_mst_row.shipvend_id:= l_po_vend_mst_row.vendor_id;
522: ELSE
523: FND_MESSAGE.SET_NAME('GMI','IC_API_INV_LOT_SHIPVENDOR_NO');
524: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
525: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
526: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
527: FND_MSG_PUB.Add;

Line 524: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);

520: THEN
521: x_ic_lots_mst_row.shipvend_id:= l_po_vend_mst_row.vendor_id;
522: ELSE
523: FND_MESSAGE.SET_NAME('GMI','IC_API_INV_LOT_SHIPVENDOR_NO');
524: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
525: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
526: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
527: FND_MSG_PUB.Add;
528: x_return_status := FND_API.G_RET_STS_ERROR;

Line 525: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);

521: x_ic_lots_mst_row.shipvend_id:= l_po_vend_mst_row.vendor_id;
522: ELSE
523: FND_MESSAGE.SET_NAME('GMI','IC_API_INV_LOT_SHIPVENDOR_NO');
524: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
525: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
526: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
527: FND_MSG_PUB.Add;
528: x_return_status := FND_API.G_RET_STS_ERROR;
529: END IF;

Line 526: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);

522: ELSE
523: FND_MESSAGE.SET_NAME('GMI','IC_API_INV_LOT_SHIPVENDOR_NO');
524: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
525: FND_MESSAGE.SET_TOKEN('LOT_NO', l_lot_no);
526: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_sublot_no);
527: FND_MSG_PUB.Add;
528: x_return_status := FND_API.G_RET_STS_ERROR;
529: END IF;
530: END IF;

Line 549: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_HOLD_DATE');

545: END IF;
546: ELSE
547: IF (p_lot_rec.ic_hold_date < x_ic_lots_mst_row.lot_created)
548: THEN
549: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_HOLD_DATE');
550: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
551: FND_MSG_PUB.Add;
552: x_return_status := FND_API.G_RET_STS_ERROR;
553: END IF;

Line 550: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

546: ELSE
547: IF (p_lot_rec.ic_hold_date < x_ic_lots_mst_row.lot_created)
548: THEN
549: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_HOLD_DATE');
550: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
551: FND_MSG_PUB.Add;
552: x_return_status := FND_API.G_RET_STS_ERROR;
553: END IF;
554: /* Jalaj Srivastava Bug 3158806

Line 569: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_MATR_DATE');

565: x_ic_lots_mst_row.creation_date + NVL(p_ic_item_cpg_row.ic_matr_days, 0);
566: ELSE
567: IF (p_lot_rec.ic_matr_date < x_ic_lots_mst_row.lot_created)
568: THEN
569: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_MATR_DATE');
570: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
571: FND_MSG_PUB.Add;
572: x_return_status := FND_API.G_RET_STS_ERROR;
573: END IF;

Line 570: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

566: ELSE
567: IF (p_lot_rec.ic_matr_date < x_ic_lots_mst_row.lot_created)
568: THEN
569: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_MATR_DATE');
570: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
571: FND_MSG_PUB.Add;
572: x_return_status := FND_API.G_RET_STS_ERROR;
573: END IF;
574: END IF;