DBA Data[Home] [Help]

APPS.GMIVLOT dependencies on FND_MSG_PUB

Line 285: FND_MSG_PUB.Add;

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
289: THEN

Line 292: FND_MSG_PUB.Add;

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:
296: /* If we're still alive carry on with validation */

Line 303: FND_MSG_PUB.Add;

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:
307: /* Check that lot number has been supplied */

Line 317: FND_MSG_PUB.Add;

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:
321: /* If item is not sublot controlled, flatten the sublot number, otherwise */

Line 354: FND_MSG_PUB.Add;

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;
358: END IF;

Line 374: FND_MSG_PUB.Add;

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;
378:

Line 405: FND_MSG_PUB.Add;

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;
409:

Line 437: FND_MSG_PUB.Add;

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;
441:

Line 469: FND_MSG_PUB.Add;

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;
473:

Line 483: FND_MSG_PUB.Add;

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:
487: /* Validate Inactive Indicator */

Line 496: FND_MSG_PUB.Add;

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:
500: /* Validate Origination Type */

Line 510: FND_MSG_PUB.Add;

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:
514: /* Validate Shipvendor Number */

Line 527: FND_MSG_PUB.Add;

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;
531:

Line 551: FND_MSG_PUB.Add;

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
555: Assign hold release date when passed by the user*/

Line 571: FND_MSG_PUB.Add;

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;
575:

Line 579: FND_MSG_PUB.Count_AND_GET

575:
576: END IF;
577: END IF;
578:
579: FND_MSG_PUB.Count_AND_GET
580: (p_count => x_msg_count, p_data => x_msg_data);
581:
582: --Jalaj Srivastava Bug 2811747
583: --commented out below.

Line 599: FND_MSG_PUB.Count_AND_GET

595: EXCEPTION
596:
597: WHEN FND_API.G_EXC_ERROR THEN
598: x_return_status := FND_API.G_RET_STS_ERROR;
599: FND_MSG_PUB.Count_AND_GET
600: ( p_count => x_msg_count,
601: p_data => x_msg_data
602: );
603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 605: FND_MSG_PUB.Count_AND_GET

601: p_data => x_msg_data
602: );
603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
605: FND_MSG_PUB.Count_AND_GET
606: ( p_count => x_msg_count,
607: p_data => x_msg_data
608: );
609: WHEN OTHERS THEN

Line 611: FND_MSG_PUB.Add_Exc_Msg

607: p_data => x_msg_data
608: );
609: WHEN OTHERS THEN
610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: FND_MSG_PUB.Add_Exc_Msg
612: ( G_PKG_NAME ,
613: l_api_name
614: );
615: FND_MSG_PUB.Count_AND_GET

Line 615: FND_MSG_PUB.Count_AND_GET

611: FND_MSG_PUB.Add_Exc_Msg
612: ( G_PKG_NAME ,
613: l_api_name
614: );
615: FND_MSG_PUB.Count_AND_GET
616: ( p_count => x_msg_count,
617: p_data => x_msg_data
618: );
619: END Validate_Lot;