eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMIVITM dependencies on FND_MESSAGE

Line 397: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_DESC1');

393: x_ic_item_mst_row.item_no := UPPER(RTRIM(p_item_rec.item_no));
394: x_ic_item_mst_row.item_desc1 := RTRIM(p_item_rec.item_desc1);
395: IF NVL(p_item_rec.item_desc1, ' ') = ' '
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

Line 399: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

395: IF NVL(p_item_rec.item_desc1, ' ') = ' '
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;

Line 415: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');

411: IF l_sy_uoms_mst_row.um_code IS NOT NULL
412: THEN
413: x_ic_item_mst_row.item_um := RTRIM(l_sy_uoms_mst_row.um_code);
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;

Line 416: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

412: THEN
413: x_ic_item_mst_row.item_um := RTRIM(l_sy_uoms_mst_row.um_code);
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

Line 417: FND_MESSAGE.SET_TOKEN('UOM',p_item_rec.item_um);

413: x_ic_item_mst_row.item_um := RTRIM(l_sy_uoms_mst_row.um_code);
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 */

Line 426: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_DUALUM_IND');

422: IF p_item_rec.dualum_ind BETWEEN 0 AND 3
423: THEN
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:

Line 427: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

423: THEN
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 */

Line 456: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');

452: END IF;
453:
454: IF x_ic_item_mst_row.item_um2 IS NULL
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

Line 457: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

453:
454: IF x_ic_item_mst_row.item_um2 IS NULL
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

Line 458: FND_MESSAGE.SET_TOKEN('UOM',p_item_rec.item_um2);

454: IF x_ic_item_mst_row.item_um2 IS NULL
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

Line 466: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_DEVIATION');

462: THEN
463: IF NVL(p_item_rec.deviation_lo,0) <= 0 OR
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;

Line 467: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

463: IF NVL(p_item_rec.deviation_lo,0) <= 0 OR
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;

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

488: THEN
489: NULL;
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:

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

489: NULL;
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

Line 507: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_SUBLOT_CTL');

503: IF NVL(p_item_rec.sublot_ctl, -1) BETWEEN 0 AND 1
504: THEN
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:

Line 508: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

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

Line 516: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_INDIVISIBLE');

512: IF NVL(p_item_rec.lot_indivisible, -1) BETWEEN 0 AND 1
513: THEN
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:

Line 517: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

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

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

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

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

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

Line 532: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_CTL');

528: x_ic_item_mst_row.sublot_ctl := 0;
529: x_ic_item_mst_row.lot_indivisible := 0;
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:

Line 533: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

529: x_ic_item_mst_row.lot_indivisible := 0;
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(?) */

Line 546: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_INACTIVE_IND');

542: IF x_ic_item_mst_row.inactive_ind BETWEEN 0 AND 1
543: THEN
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:

Line 547: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

543: THEN
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 */

Line 557: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOCT_CTL');

553: IF x_ic_item_mst_row.loct_ctl BETWEEN 0 AND 2
554: THEN
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:

Line 558: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

554: THEN
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, */

Line 587: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QC_GRADE');

583: END IF;
584:
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 */

Line 588: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

584:
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:

Line 596: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_RETEST_INTERVAL');

592:
593: x_ic_item_mst_row.retest_interval := NVL(p_item_rec.retest_interval,0);
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:

Line 597: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

593: x_ic_item_mst_row.retest_interval := NVL(p_item_rec.retest_interval,0);
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);

Line 604: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_SHELF_LIFE');

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

Line 605: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

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
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, ' ') <> ' '

Line 622: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_EXPACTION_CODE');

618: --Jalaj Srivastava Bug 1617398
619: --expaction code should not be a required field
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:

Line 623: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

619: --expaction code should not be a required field
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);

Line 630: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_EXPACTION_INTERVAL');

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
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: /*************************************************

Line 631: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

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
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.

Line 639: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_GRADE_CTL');

635: BUG#1653385 - moved this end if up.
636: END IF;
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:

Line 640: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

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

Line 660: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_STATUS');

656: END IF;
657:
658: IF x_ic_item_mst_row.lot_status IS NULL
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;

Line 661: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

657:
658: IF x_ic_item_mst_row.lot_status IS NULL
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;

Line 662: FND_MESSAGE.SET_TOKEN('LOT_STATUS', p_item_rec.lot_status);

658: IF x_ic_item_mst_row.lot_status IS NULL
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

Line 667: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_STATUS_CTL');

663: FND_MSG_PUB.Add;
664: END IF;
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

Line 668: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

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

Line 689: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_EXPERIMENTAL');

685: IF x_ic_item_mst_row.experimental_ind BETWEEN 0 AND 1
686: THEN
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:

Line 690: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

686: THEN
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/ */

Line 723: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_CLASS');

719: x_ic_item_mst_row.seq_dpnd_class := UPPER(RTRIM(p_item_rec.seq_dpnd_class));
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: /*=================================================

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

758: IF l_ic_item_mst_row.item_id IS NOT NULL
759: THEN
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;

Line 763: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

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

Line 779: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QCITEM_NO');

775: IF l_ic_item_mst_row.item_id IS NOT NULL
776: THEN
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;

Line 780: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.qcitem_no);

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

Line 840: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ONT_SOURCE');

836: IF p_item_rec.ont_pricing_qty_source BETWEEN 0 AND 1
837: THEN
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:

Line 841: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

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

Line 851: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ONT_SOURCE');

847: or (p_item_rec.ont_pricing_qty_source > 0
848: and UPPER(NVL(FND_PROFILE.VALUE('GML_OM_INTEGRATION'),'N')) = 'N' )
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:

Line 852: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

848: and UPPER(NVL(FND_PROFILE.VALUE('GML_OM_INTEGRATION'),'N')) = 'N' )
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);

Line 867: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_MATR_DAYS');

863: x_ic_item_cpg_row.item_id := NULL;
864: x_ic_item_cpg_row.ic_matr_days := NVL(p_item_rec.ic_matr_days,0);
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:

Line 868: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

864: x_ic_item_cpg_row.ic_matr_days := NVL(p_item_rec.ic_matr_days,0);
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;

Line 881: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_HOLD_DAYS');

877: x_ic_item_mst_row.level_code := x_ic_item_cpg_row.ic_hold_days;
878:
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;

Line 882: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_rec.item_no);

878:
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: */