DBA Data[Home] [Help]

APPS.GMIVITM dependencies on FND_MSG_PUB

Line 400: FND_MSG_PUB.Add;

396: THEN
397: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_DESC1');
398:
399: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
400: FND_MSG_PUB.Add;
401: ELSE
402: x_ic_item_mst_row.item_desc2 := RTRIM(p_item_rec.item_desc2);
403: END IF;
404:

Line 418: FND_MSG_PUB.Add;

414: ELSE
415: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');
416: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
417: FND_MESSAGE.SET_TOKEN('UOM',p_item_rec.item_um);
418: FND_MSG_PUB.Add;
419: END IF;
420: -- END BUG#2461984 VAK
421: /* Dual unit of measure indicator */
422: IF p_item_rec.dualum_ind BETWEEN 0 AND 3

Line 428: FND_MSG_PUB.Add;

424: x_ic_item_mst_row.dualum_ind := p_item_rec.dualum_ind;
425: ELSE
426: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_DUALUM_IND');
427: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
428: FND_MSG_PUB.Add;
429: END IF;
430:
431: /* Secondary Unit of Measure - ignore if dualum_ind=0 */
432: /* For any other case, ensure it's present and not the */

Line 459: FND_MSG_PUB.Add;

455: THEN
456: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');
457: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
458: FND_MESSAGE.SET_TOKEN('UOM',p_item_rec.item_um2);
459: FND_MSG_PUB.Add;
460: ELSE
461: IF x_ic_item_mst_row.dualum_ind > 1
462: THEN
463: IF NVL(p_item_rec.deviation_lo,0) <= 0 OR

Line 468: FND_MSG_PUB.Add;

464: NVL(p_item_rec.deviation_hi,0) <= 0
465: THEN
466: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_DEVIATION');
467: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
468: FND_MSG_PUB.Add;
469: ELSE
470: x_ic_item_mst_row.deviation_lo := p_item_rec.deviation_lo;
471: x_ic_item_mst_row.deviation_hi := p_item_rec.deviation_hi;
472: END IF;

Line 494: FND_MSG_PUB.Add;

490: ELSE
491: x_ic_item_mst_row.noninv_ind:= NULL;
492: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_NONINV_IND');
493: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
494: FND_MSG_PUB.Add;
495: END IF;
496:
497: IF NVL(p_item_rec.lot_ctl, -1) BETWEEN 0 AND 1
498: THEN

Line 509: FND_MSG_PUB.Add;

505: x_ic_item_mst_row.sublot_ctl := p_item_rec.sublot_ctl;
506: ELSE
507: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_SUBLOT_CTL');
508: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
509: FND_MSG_PUB.Add;
510: END IF;
511:
512: IF NVL(p_item_rec.lot_indivisible, -1) BETWEEN 0 AND 1
513: THEN

Line 518: FND_MSG_PUB.Add;

514: x_ic_item_mst_row.lot_indivisible := p_item_rec.lot_indivisible;
515: ELSE
516: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_INDIVISIBLE');
517: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
518: FND_MSG_PUB.Add;
519: END IF;
520:
521: IF x_ic_item_mst_row.noninv_ind = 1
522: THEN

Line 525: FND_MSG_PUB.Add;

521: IF x_ic_item_mst_row.noninv_ind = 1
522: THEN
523: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_NONINV_IND');
524: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
525: FND_MSG_PUB.Add;
526: END IF;
527: ELSE
528: x_ic_item_mst_row.sublot_ctl := 0;
529: x_ic_item_mst_row.lot_indivisible := 0;

Line 534: FND_MSG_PUB.Add;

530: END IF;
531: ELSE
532: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_CTL');
533: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
534: FND_MSG_PUB.Add;
535: END IF;
536:
537: /* Match type is not used(?) */
538: x_ic_item_mst_row.match_type := 3;

Line 548: FND_MSG_PUB.Add;

544: NULL;
545: ELSE
546: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_INACTIVE_IND');
547: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
548: FND_MSG_PUB.Add;
549: END IF;
550:
551: /* Location control flag */
552: x_ic_item_mst_row.loct_ctl := NVL(p_item_rec.loct_ctl,0);

Line 559: FND_MSG_PUB.Add;

555: NULL;
556: ELSE
557: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOCT_CTL');
558: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
559: FND_MSG_PUB.Add;
560: END IF;
561:
562: /* Grade, status control etc. If item is lot controlled, */
563: /* validate everything, else default it. */

Line 589: FND_MSG_PUB.Add;

585: IF x_ic_item_mst_row.qc_grade IS NULL
586: THEN
587: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QC_GRADE');
588: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
589: FND_MSG_PUB.Add;
590: END IF;
591: END IF; /* moved here for bug#1653385 */
592:
593: x_ic_item_mst_row.retest_interval := NVL(p_item_rec.retest_interval,0);

Line 598: FND_MSG_PUB.Add;

594: IF x_ic_item_mst_row.retest_interval < 0
595: THEN
596: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_RETEST_INTERVAL');
597: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
598: FND_MSG_PUB.Add;
599: END IF;
600:
601: x_ic_item_mst_row.shelf_life := NVL(p_item_rec.shelf_life,0);
602: IF x_ic_item_mst_row.shelf_life < 0

Line 606: FND_MSG_PUB.Add;

602: IF x_ic_item_mst_row.shelf_life < 0
603: THEN
604: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_SHELF_LIFE');
605: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
606: FND_MSG_PUB.Add;
607: END IF;
608:
609: IF NVL(p_item_rec.expaction_code, ' ') <> ' '
610: THEN

Line 624: FND_MSG_PUB.Add;

620: /* IF x_ic_item_mst_row.expaction_code IS NULL
621: THEN
622: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_EXPACTION_CODE');
623: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
624: FND_MSG_PUB.Add;
625: END IF; */
626:
627: x_ic_item_mst_row.expaction_interval := NVL(p_item_rec.expaction_interval,0);
628: IF x_ic_item_mst_row.expaction_interval < 0

Line 632: FND_MSG_PUB.Add;

628: IF x_ic_item_mst_row.expaction_interval < 0
629: THEN
630: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_EXPACTION_INTERVAL');
631: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
632: FND_MSG_PUB.Add;
633: END IF;
634: /*************************************************
635: BUG#1653385 - moved this end if up.
636: END IF;

Line 641: FND_MSG_PUB.Add;

637: ************************************************/
638: ELSE
639: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_GRADE_CTL');
640: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
641: FND_MSG_PUB.Add;
642: END IF;
643:
644: x_ic_item_mst_row.status_ctl := NVL(p_item_rec.status_ctl,0);
645:

Line 663: FND_MSG_PUB.Add;

659: THEN
660: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_STATUS');
661: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
662: FND_MESSAGE.SET_TOKEN('LOT_STATUS', p_item_rec.lot_status);
663: FND_MSG_PUB.Add;
664: END IF;
665: END IF;
666: ELSE
667: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_STATUS_CTL');

Line 669: FND_MSG_PUB.Add;

665: END IF;
666: ELSE
667: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_STATUS_CTL');
668: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
669: FND_MSG_PUB.Add;
670: END IF;
671: ELSE
672: x_ic_item_mst_row.grade_ctl := 0;
673: x_ic_item_mst_row.qc_grade := NULL;

Line 691: FND_MSG_PUB.Add;

687: NULL;
688: ELSE
689: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_EXPERIMENTAL');
690: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
691: FND_MSG_PUB.Add;
692: END IF;
693:
694: /* GL class/Inv Class/Sales Class/Ship Class/Frt Class/ */
695: /* Price Class/Storage Class/Purch Class/Tax Class/Customs Class/ */

Line 724: FND_MSG_PUB.Add;

720: x_ic_item_mst_row.inv_type := UPPER(RTRIM(p_item_rec.inv_type));
721: --END BUG#2461984
722: ELSE
723: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_CLASS');
724: FND_MSG_PUB.Add;
725: END IF;
726:
727: /*=================================================
728: Joe DiIorio 10/23/2001 BUG#1989860 11.5.1H

Line 764: FND_MSG_PUB.Add;

760: x_ic_item_mst_row.whse_item_id := l_ic_item_mst_row.item_id;
761: ELSE
762: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_ITEM_NO');
763: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
764: FND_MSG_PUB.Add;
765: END IF;
766: END IF;
767:
768:

Line 781: FND_MSG_PUB.Add;

777: x_ic_item_mst_row.qcitem_id := l_ic_item_mst_row.item_id;
778: ELSE
779: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QCITEM_NO');
780: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.qcitem_no);
781: FND_MSG_PUB.Add;
782: END IF;
783: END IF;
784:
785: /* Exported date */

Line 842: FND_MSG_PUB.Add;

838: x_ic_item_mst_row.ont_pricing_qty_source := NVL(p_item_rec.ont_pricing_qty_source,0);
839: ELSE
840: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ONT_SOURCE');
841: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
842: FND_MSG_PUB.Add;
843: END IF;
844:
845: IF (p_item_rec.ont_pricing_qty_source > 0
846: and x_ic_item_mst_row.dualum_ind < 1 )

Line 853: FND_MSG_PUB.Add;

849:
850: THEN
851: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ONT_SOURCE');
852: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
853: FND_MSG_PUB.Add;
854: END IF;
855:
856: x_ic_item_mst_row.ont_pricing_qty_source := NVL(p_item_rec.ont_pricing_qty_source,0);
857:

Line 869: FND_MSG_PUB.Add;

865: IF x_ic_item_cpg_row.ic_matr_days < 0
866: THEN
867: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_MATR_DAYS');
868: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
869: FND_MSG_PUB.Add;
870: END IF;
871:
872: x_ic_item_cpg_row.ic_hold_days := p_item_rec.ic_hold_days;
873: /* Jalaj Srivastava Bug 3158806

Line 883: FND_MSG_PUB.Add;

879: IF x_ic_item_cpg_row.ic_matr_days < 0
880: THEN
881: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_HOLD_DAYS');
882: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);
883: FND_MSG_PUB.Add;
884: END IF;
885: END IF;
886: /* See how we got on: */
887:

Line 888: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

884: END IF;
885: END IF;
886: /* See how we got on: */
887:
888: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
889: , p_data => x_msg_data
890: );
891: IF x_msg_count > 0
892: THEN

Line 913: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

909:
910: EXCEPTION
911: WHEN FND_API.G_EXC_ERROR THEN
912: x_return_status := FND_API.G_RET_STS_ERROR;
913: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
914: , p_data => x_msg_data
915: );
916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
917:

Line 919: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

915: );
916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
917:
918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
919: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
920: , p_data => x_msg_data
921: );
922: WHEN OTHERS THEN
923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 924: /* IF FND_MSG_PUB.check_msg_level */

920: , p_data => x_msg_data
921: );
922: WHEN OTHERS THEN
923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
924: /* IF FND_MSG_PUB.check_msg_level */
925: /* (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) */
926: /* THEN */
927:
928: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

Line 925: /* (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) */

921: );
922: WHEN OTHERS THEN
923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
924: /* IF FND_MSG_PUB.check_msg_level */
925: /* (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) */
926: /* THEN */
927:
928: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
929: , l_api_name

Line 928: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

924: /* IF FND_MSG_PUB.check_msg_level */
925: /* (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) */
926: /* THEN */
927:
928: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
929: , l_api_name
930: );
931:
932: /* END IF; */

Line 933: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

929: , l_api_name
930: );
931:
932: /* END IF; */
933: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
934: , p_data => x_msg_data
935: );
936:
937: END Validate_Item;