DBA Data[Home] [Help]

APPS.GMIVQTY dependencies on FND_MESSAGE

Line 358: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOCATION');

354:
355: WHEN OTHERS
356: THEN
357: -- BEGIN BUG#2340824 Ravishanker B.
358: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOCATION');
359: FND_MESSAGE.SET_TOKEN('ITEM_NO', P_qty_rec.item_no);
360: --IF there is some problem in the 1st Select statement
361: --the l_count is NULL and control gets into the IF part
362: IF l_count IS NULL THEN

Line 359: FND_MESSAGE.SET_TOKEN('ITEM_NO', P_qty_rec.item_no);

355: WHEN OTHERS
356: THEN
357: -- BEGIN BUG#2340824 Ravishanker B.
358: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOCATION');
359: FND_MESSAGE.SET_TOKEN('ITEM_NO', P_qty_rec.item_no);
360: --IF there is some problem in the 1st Select statement
361: --the l_count is NULL and control gets into the IF part
362: IF l_count IS NULL THEN
363: FND_MESSAGE.SET_TOKEN('WHSE_CODE', P_qty_rec.from_whse_code);

Line 363: FND_MESSAGE.SET_TOKEN('WHSE_CODE', P_qty_rec.from_whse_code);

359: FND_MESSAGE.SET_TOKEN('ITEM_NO', P_qty_rec.item_no);
360: --IF there is some problem in the 1st Select statement
361: --the l_count is NULL and control gets into the IF part
362: IF l_count IS NULL THEN
363: FND_MESSAGE.SET_TOKEN('WHSE_CODE', P_qty_rec.from_whse_code);
364: FND_MESSAGE.SET_TOKEN('LOCATION',P_qty_rec.from_location);
365: --IF there is some problem in the 2nd Select statement
366: --the l_count shall be '1' and control gets into the ELSE part
367: ELSE

Line 364: FND_MESSAGE.SET_TOKEN('LOCATION',P_qty_rec.from_location);

360: --IF there is some problem in the 1st Select statement
361: --the l_count is NULL and control gets into the IF part
362: IF l_count IS NULL THEN
363: FND_MESSAGE.SET_TOKEN('WHSE_CODE', P_qty_rec.from_whse_code);
364: FND_MESSAGE.SET_TOKEN('LOCATION',P_qty_rec.from_location);
365: --IF there is some problem in the 2nd Select statement
366: --the l_count shall be '1' and control gets into the ELSE part
367: ELSE
368: FND_MESSAGE.SET_TOKEN('WHSE_CODE', P_qty_rec.to_whse_code);

Line 368: FND_MESSAGE.SET_TOKEN('WHSE_CODE', P_qty_rec.to_whse_code);

364: FND_MESSAGE.SET_TOKEN('LOCATION',P_qty_rec.from_location);
365: --IF there is some problem in the 2nd Select statement
366: --the l_count shall be '1' and control gets into the ELSE part
367: ELSE
368: FND_MESSAGE.SET_TOKEN('WHSE_CODE', P_qty_rec.to_whse_code);
369: FND_MESSAGE.SET_TOKEN('LOCATION',P_qty_rec.to_location);
370: END IF;
371: FND_MSG_PUB.Add;
372: -- END BUG#2340824

Line 369: FND_MESSAGE.SET_TOKEN('LOCATION',P_qty_rec.to_location);

365: --IF there is some problem in the 2nd Select statement
366: --the l_count shall be '1' and control gets into the ELSE part
367: ELSE
368: FND_MESSAGE.SET_TOKEN('WHSE_CODE', P_qty_rec.to_whse_code);
369: FND_MESSAGE.SET_TOKEN('LOCATION',P_qty_rec.to_location);
370: END IF;
371: FND_MSG_PUB.Add;
372: -- END BUG#2340824
373: RETURN FALSE;

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

542: );
543:
544: IF l_user_id = 0
545: THEN
546: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_USER_NAME');
547: FND_MESSAGE.SET_TOKEN('USER_NAME', l_user_name);
548: FND_MSG_PUB.Add;
549: RAISE FND_API.G_EXC_ERROR;
550: END IF;

Line 547: FND_MESSAGE.SET_TOKEN('USER_NAME', l_user_name);

543:
544: IF l_user_id = 0
545: THEN
546: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_USER_NAME');
547: FND_MESSAGE.SET_TOKEN('USER_NAME', l_user_name);
548: FND_MSG_PUB.Add;
549: RAISE FND_API.G_EXC_ERROR;
550: END IF;
551:

Line 554: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_CO_CODE');

550: END IF;
551:
552: IF NOT GMA_VALID_GRP.Validate_co_code(p_qty_rec.co_code)
553: THEN
554: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_CO_CODE');
555: FND_MESSAGE.SET_TOKEN('CO_CODE',p_qty_rec.co_code);
556: FND_MSG_PUB.Add;
557: RAISE FND_API.G_EXC_ERROR;
558: END IF;

Line 555: FND_MESSAGE.SET_TOKEN('CO_CODE',p_qty_rec.co_code);

551:
552: IF NOT GMA_VALID_GRP.Validate_co_code(p_qty_rec.co_code)
553: THEN
554: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_CO_CODE');
555: FND_MESSAGE.SET_TOKEN('CO_CODE',p_qty_rec.co_code);
556: FND_MSG_PUB.Add;
557: RAISE FND_API.G_EXC_ERROR;
558: END IF;
559:

Line 562: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ORGN_CODE');

558: END IF;
559:
560: IF NOT GMA_VALID_GRP.Validate_orgn_code(l_qty_rec.orgn_code)
561: THEN
562: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ORGN_CODE');
563: FND_MESSAGE.SET_TOKEN('ORGN_CODE',p_qty_rec.orgn_code);
564: FND_MSG_PUB.Add;
565: RAISE FND_API.G_EXC_ERROR;
566: END IF;

Line 563: FND_MESSAGE.SET_TOKEN('ORGN_CODE',p_qty_rec.orgn_code);

559:
560: IF NOT GMA_VALID_GRP.Validate_orgn_code(l_qty_rec.orgn_code)
561: THEN
562: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ORGN_CODE');
563: FND_MESSAGE.SET_TOKEN('ORGN_CODE',p_qty_rec.orgn_code);
564: FND_MSG_PUB.Add;
565: RAISE FND_API.G_EXC_ERROR;
566: END IF;
567:

Line 572: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_TRANS_TYPE');

568: IF l_trans_type BETWEEN 1 AND 10
569: THEN
570: NULL;
571: ELSE
572: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_TRANS_TYPE');
573: FND_MESSAGE.SET_TOKEN('TRANS_TYPE',l_trans_type);
574: FND_MSG_PUB.Add;
575: RAISE FND_API.G_EXC_ERROR;
576: END IF;

Line 573: FND_MESSAGE.SET_TOKEN('TRANS_TYPE',l_trans_type);

569: THEN
570: NULL;
571: ELSE
572: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_TRANS_TYPE');
573: FND_MESSAGE.SET_TOKEN('TRANS_TYPE',l_trans_type);
574: FND_MSG_PUB.Add;
575: RAISE FND_API.G_EXC_ERROR;
576: END IF;
577:

Line 583: FND_MESSAGE.SET_NAME('GMI','IC_API_INV_TRANS_TYPE_FOR_ITEM');

579: /* it's not, complain, otherwise set up a few defaults. */
580: IF p_ic_item_mst_row.grade_ctl = 0 AND l_trans_type IN (5,10)
581: OR p_ic_item_mst_row.status_ctl = 0 AND l_trans_type IN (4,9)
582: THEN
583: FND_MESSAGE.SET_NAME('GMI','IC_API_INV_TRANS_TYPE_FOR_ITEM');
584: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
585: FND_MESSAGE.SET_TOKEN('TRANS_TYPE', l_trans_type);
586: FND_MSG_PUB.Add;
587: RAISE FND_API.G_EXC_ERROR;

Line 584: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

580: IF p_ic_item_mst_row.grade_ctl = 0 AND l_trans_type IN (5,10)
581: OR p_ic_item_mst_row.status_ctl = 0 AND l_trans_type IN (4,9)
582: THEN
583: FND_MESSAGE.SET_NAME('GMI','IC_API_INV_TRANS_TYPE_FOR_ITEM');
584: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
585: FND_MESSAGE.SET_TOKEN('TRANS_TYPE', l_trans_type);
586: FND_MSG_PUB.Add;
587: RAISE FND_API.G_EXC_ERROR;
588: ELSE

Line 585: FND_MESSAGE.SET_TOKEN('TRANS_TYPE', l_trans_type);

581: OR p_ic_item_mst_row.status_ctl = 0 AND l_trans_type IN (4,9)
582: THEN
583: FND_MESSAGE.SET_NAME('GMI','IC_API_INV_TRANS_TYPE_FOR_ITEM');
584: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
585: FND_MESSAGE.SET_TOKEN('TRANS_TYPE', l_trans_type);
586: FND_MSG_PUB.Add;
587: RAISE FND_API.G_EXC_ERROR;
588: ELSE
589: /* For STSI and GRDI default the uoms. For other types */

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

668: OR p_ic_item_mst_row.delete_mark = 1
669: OR p_ic_item_mst_row.noninv_ind = 1
670: OR p_ic_item_mst_row.inactive_ind =1 AND GMIGUTL.IC$API_ALLOW_INACTIVE=0
671: THEN
672: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
673: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
674: FND_MSG_PUB.Add;
675: RAISE FND_API.G_EXC_ERROR;
676: END IF;

Line 673: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

669: OR p_ic_item_mst_row.noninv_ind = 1
670: OR p_ic_item_mst_row.inactive_ind =1 AND GMIGUTL.IC$API_ALLOW_INACTIVE=0
671: THEN
672: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
673: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
674: FND_MSG_PUB.Add;
675: RAISE FND_API.G_EXC_ERROR;
676: END IF;
677:

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

689: IF NVL(l_qty_rec.lot_no,GMIGUTL.IC$DEFAULT_LOT)=GMIGUTL.IC$DEFAULT_LOT
690: OR p_ic_lots_mst_row.delete_mark = 1
691: OR p_ic_lots_mst_row.inactive_ind = 1 AND GMIGUTL.IC$API_ALLOW_INACTIVE = 0
692: THEN
693: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
694: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
695: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
696: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
697: FND_MSG_PUB.Add;

Line 694: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

690: OR p_ic_lots_mst_row.delete_mark = 1
691: OR p_ic_lots_mst_row.inactive_ind = 1 AND GMIGUTL.IC$API_ALLOW_INACTIVE = 0
692: THEN
693: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
694: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
695: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
696: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
697: FND_MSG_PUB.Add;
698: RAISE FND_API.G_EXC_ERROR;

Line 695: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);

691: OR p_ic_lots_mst_row.inactive_ind = 1 AND GMIGUTL.IC$API_ALLOW_INACTIVE = 0
692: THEN
693: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
694: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
695: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
696: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
697: FND_MSG_PUB.Add;
698: RAISE FND_API.G_EXC_ERROR;
699: END IF;

Line 696: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);

692: THEN
693: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
694: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
695: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
696: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
697: FND_MSG_PUB.Add;
698: RAISE FND_API.G_EXC_ERROR;
699: END IF;
700: ELSE

Line 726: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ORGN_CODE');

722: IF co_orgn_valid (l_qty_rec)
723: THEN
724: NULL;
725: ELSE
726: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ORGN_CODE');
727: FND_MESSAGE.SET_TOKEN('ORGN_CODE',l_qty_rec.orgn_code);
728: FND_MSG_PUB.Add;
729: RAISE FND_API.G_EXC_ERROR;
730: END IF;

Line 727: FND_MESSAGE.SET_TOKEN('ORGN_CODE',l_qty_rec.orgn_code);

723: THEN
724: NULL;
725: ELSE
726: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ORGN_CODE');
727: FND_MESSAGE.SET_TOKEN('ORGN_CODE',l_qty_rec.orgn_code);
728: FND_MSG_PUB.Add;
729: RAISE FND_API.G_EXC_ERROR;
730: END IF;
731: ELSE

Line 736: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ORGN_CODE');

732: IF co_orgn_whse_valid (l_qty_rec, l_from_loct_ctl, l_to_loct_ctl)
733: THEN
734: NULL;
735: ELSE
736: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ORGN_CODE');
737: FND_MESSAGE.SET_TOKEN('ORGN_CODE',l_qty_rec.orgn_code);
738: FND_MSG_PUB.Add;
739: RAISE FND_API.G_EXC_ERROR;
740: END IF;

Line 737: FND_MESSAGE.SET_TOKEN('ORGN_CODE',l_qty_rec.orgn_code);

733: THEN
734: NULL;
735: ELSE
736: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ORGN_CODE');
737: FND_MESSAGE.SET_TOKEN('ORGN_CODE',l_qty_rec.orgn_code);
738: FND_MSG_PUB.Add;
739: RAISE FND_API.G_EXC_ERROR;
740: END IF;
741: END IF;

Line 792: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOCATION');

788: END IF;
789:
790: IF l_bad_location = 1
791: THEN
792: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOCATION');
793: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_qty_rec.item_no);
794: FND_MESSAGE.SET_TOKEN('WHSE_CODE', l_qty_rec.from_whse_code);
795: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
796: FND_MSG_PUB.Add;

Line 793: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_qty_rec.item_no);

789:
790: IF l_bad_location = 1
791: THEN
792: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOCATION');
793: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_qty_rec.item_no);
794: FND_MESSAGE.SET_TOKEN('WHSE_CODE', l_qty_rec.from_whse_code);
795: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
796: FND_MSG_PUB.Add;
797: RAISE FND_API.G_EXC_ERROR;

Line 794: FND_MESSAGE.SET_TOKEN('WHSE_CODE', l_qty_rec.from_whse_code);

790: IF l_bad_location = 1
791: THEN
792: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOCATION');
793: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_qty_rec.item_no);
794: FND_MESSAGE.SET_TOKEN('WHSE_CODE', l_qty_rec.from_whse_code);
795: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
796: FND_MSG_PUB.Add;
797: RAISE FND_API.G_EXC_ERROR;
798: -- BEGIN BUG#2340824 Ravishanker B.

Line 795: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);

791: THEN
792: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOCATION');
793: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_qty_rec.item_no);
794: FND_MESSAGE.SET_TOKEN('WHSE_CODE', l_qty_rec.from_whse_code);
795: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
796: FND_MSG_PUB.Add;
797: RAISE FND_API.G_EXC_ERROR;
798: -- BEGIN BUG#2340824 Ravishanker B.
799: ELSE

Line 829: FND_MESSAGE.SET_NAME('GMI','IC_API_UNPOSTED_JNL_QC_GRADE');

825: , p_lot_id => p_ic_lots_mst_row.lot_id
826: , p_qc_grade => l_qty_rec.qc_grade
827: )
828: THEN
829: FND_MESSAGE.SET_NAME('GMI','IC_API_UNPOSTED_JNL_QC_GRADE');
830: FND_MESSAGE.SET_TOKEN('QC_GRADE',l_qty_rec.qc_grade);
831: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
832: FND_MSG_PUB.Add;
833: RAISE FND_API.G_EXC_ERROR;

Line 830: FND_MESSAGE.SET_TOKEN('QC_GRADE',l_qty_rec.qc_grade);

826: , p_qc_grade => l_qty_rec.qc_grade
827: )
828: THEN
829: FND_MESSAGE.SET_NAME('GMI','IC_API_UNPOSTED_JNL_QC_GRADE');
830: FND_MESSAGE.SET_TOKEN('QC_GRADE',l_qty_rec.qc_grade);
831: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
832: FND_MSG_PUB.Add;
833: RAISE FND_API.G_EXC_ERROR;
834: END IF;

Line 831: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

827: )
828: THEN
829: FND_MESSAGE.SET_NAME('GMI','IC_API_UNPOSTED_JNL_QC_GRADE');
830: FND_MESSAGE.SET_TOKEN('QC_GRADE',l_qty_rec.qc_grade);
831: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
832: FND_MSG_PUB.Add;
833: RAISE FND_API.G_EXC_ERROR;
834: END IF;
835: ELSE

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

832: FND_MSG_PUB.Add;
833: RAISE FND_API.G_EXC_ERROR;
834: END IF;
835: ELSE
836: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QC_GRADE');
837: FND_MESSAGE.SET_TOKEN('QC_GRADE',l_qty_rec.qc_grade);
838: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
839: FND_MSG_PUB.Add;
840: RAISE FND_API.G_EXC_ERROR;

Line 837: FND_MESSAGE.SET_TOKEN('QC_GRADE',l_qty_rec.qc_grade);

833: RAISE FND_API.G_EXC_ERROR;
834: END IF;
835: ELSE
836: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QC_GRADE');
837: FND_MESSAGE.SET_TOKEN('QC_GRADE',l_qty_rec.qc_grade);
838: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
839: FND_MSG_PUB.Add;
840: RAISE FND_API.G_EXC_ERROR;
841: END IF;

Line 838: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

834: END IF;
835: ELSE
836: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QC_GRADE');
837: FND_MESSAGE.SET_TOKEN('QC_GRADE',l_qty_rec.qc_grade);
838: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
839: FND_MSG_PUB.Add;
840: RAISE FND_API.G_EXC_ERROR;
841: END IF;
842: ELSE

Line 843: FND_MESSAGE.SET_NAME('GMI','IC_API_SAME_QC_GRADE');

839: FND_MSG_PUB.Add;
840: RAISE FND_API.G_EXC_ERROR;
841: END IF;
842: ELSE
843: FND_MESSAGE.SET_NAME('GMI','IC_API_SAME_QC_GRADE');
844: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
845: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
846: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
847: FND_MSG_PUB.Add;

Line 844: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

840: RAISE FND_API.G_EXC_ERROR;
841: END IF;
842: ELSE
843: FND_MESSAGE.SET_NAME('GMI','IC_API_SAME_QC_GRADE');
844: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
845: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
846: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
847: FND_MSG_PUB.Add;
848: RAISE FND_API.G_EXC_ERROR;

Line 845: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);

841: END IF;
842: ELSE
843: FND_MESSAGE.SET_NAME('GMI','IC_API_SAME_QC_GRADE');
844: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
845: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
846: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
847: FND_MSG_PUB.Add;
848: RAISE FND_API.G_EXC_ERROR;
849: END IF;

Line 846: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);

842: ELSE
843: FND_MESSAGE.SET_NAME('GMI','IC_API_SAME_QC_GRADE');
844: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
845: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
846: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
847: FND_MSG_PUB.Add;
848: RAISE FND_API.G_EXC_ERROR;
849: END IF;
850: ELSE

Line 872: FND_MESSAGE.SET_NAME('GMI','IC_API_CANNOT_POST_CLOSED');

868: , l_qty_rec.from_whse_code
869: );
870: IF l_return_val <> 0
871: THEN
872: FND_MESSAGE.SET_NAME('GMI','IC_API_CANNOT_POST_CLOSED');
873: FND_MESSAGE.SET_TOKEN('ITEM_NO' , l_qty_rec.item_no);
874: FND_MESSAGE.SET_TOKEN('TRANS_DATE', l_qty_rec.trans_date);
875: FND_MSG_PUB.Add;
876: RAISE FND_API.G_EXC_ERROR;

Line 873: FND_MESSAGE.SET_TOKEN('ITEM_NO' , l_qty_rec.item_no);

869: );
870: IF l_return_val <> 0
871: THEN
872: FND_MESSAGE.SET_NAME('GMI','IC_API_CANNOT_POST_CLOSED');
873: FND_MESSAGE.SET_TOKEN('ITEM_NO' , l_qty_rec.item_no);
874: FND_MESSAGE.SET_TOKEN('TRANS_DATE', l_qty_rec.trans_date);
875: FND_MSG_PUB.Add;
876: RAISE FND_API.G_EXC_ERROR;
877: -- Bug 2665243 Sastry removed to_char

Line 874: FND_MESSAGE.SET_TOKEN('TRANS_DATE', l_qty_rec.trans_date);

870: IF l_return_val <> 0
871: THEN
872: FND_MESSAGE.SET_NAME('GMI','IC_API_CANNOT_POST_CLOSED');
873: FND_MESSAGE.SET_TOKEN('ITEM_NO' , l_qty_rec.item_no);
874: FND_MESSAGE.SET_TOKEN('TRANS_DATE', l_qty_rec.trans_date);
875: FND_MSG_PUB.Add;
876: RAISE FND_API.G_EXC_ERROR;
877: -- Bug 2665243 Sastry removed to_char
878: ELSIF l_qty_rec.trans_date > SYSDATE

Line 880: FND_MESSAGE.SET_NAME('GMI','IC_API_CANNOT_POST_FUTURE');

876: RAISE FND_API.G_EXC_ERROR;
877: -- Bug 2665243 Sastry removed to_char
878: ELSIF l_qty_rec.trans_date > SYSDATE
879: THEN
880: FND_MESSAGE.SET_NAME('GMI','IC_API_CANNOT_POST_FUTURE');
881: FND_MESSAGE.SET_TOKEN('ITEM_NO' , l_qty_rec.item_no);
882: FND_MESSAGE.SET_TOKEN('TRANS_DATE', l_qty_rec.trans_date);
883: FND_MSG_PUB.Add;
884: RAISE FND_API.G_EXC_ERROR;

Line 881: FND_MESSAGE.SET_TOKEN('ITEM_NO' , l_qty_rec.item_no);

877: -- Bug 2665243 Sastry removed to_char
878: ELSIF l_qty_rec.trans_date > SYSDATE
879: THEN
880: FND_MESSAGE.SET_NAME('GMI','IC_API_CANNOT_POST_FUTURE');
881: FND_MESSAGE.SET_TOKEN('ITEM_NO' , l_qty_rec.item_no);
882: FND_MESSAGE.SET_TOKEN('TRANS_DATE', l_qty_rec.trans_date);
883: FND_MSG_PUB.Add;
884: RAISE FND_API.G_EXC_ERROR;
885: END IF;

Line 882: FND_MESSAGE.SET_TOKEN('TRANS_DATE', l_qty_rec.trans_date);

878: ELSIF l_qty_rec.trans_date > SYSDATE
879: THEN
880: FND_MESSAGE.SET_NAME('GMI','IC_API_CANNOT_POST_FUTURE');
881: FND_MESSAGE.SET_TOKEN('ITEM_NO' , l_qty_rec.item_no);
882: FND_MESSAGE.SET_TOKEN('TRANS_DATE', l_qty_rec.trans_date);
883: FND_MSG_PUB.Add;
884: RAISE FND_API.G_EXC_ERROR;
885: END IF;
886: END IF;

Line 904: FND_MESSAGE.SET_NAME('GMI','IC_API_DEC_NOT_ALLOWED');

900: THEN
901: IF l_sy_reas_cds_row.reason_type = 1 AND
902: l_qty_rec.trans_qty < 0
903: THEN
904: FND_MESSAGE.SET_NAME('GMI','IC_API_DEC_NOT_ALLOWED');
905: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
906: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
907: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
908: FND_MSG_PUB.Add;

Line 905: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

901: IF l_sy_reas_cds_row.reason_type = 1 AND
902: l_qty_rec.trans_qty < 0
903: THEN
904: FND_MESSAGE.SET_NAME('GMI','IC_API_DEC_NOT_ALLOWED');
905: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
906: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
907: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
908: FND_MSG_PUB.Add;
909: RAISE FND_API.G_EXC_ERROR;

Line 906: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);

902: l_qty_rec.trans_qty < 0
903: THEN
904: FND_MESSAGE.SET_NAME('GMI','IC_API_DEC_NOT_ALLOWED');
905: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
906: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
907: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
908: FND_MSG_PUB.Add;
909: RAISE FND_API.G_EXC_ERROR;
910: ELSIF l_sy_reas_cds_row.reason_type = 2 AND

Line 907: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);

903: THEN
904: FND_MESSAGE.SET_NAME('GMI','IC_API_DEC_NOT_ALLOWED');
905: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
906: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
907: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
908: FND_MSG_PUB.Add;
909: RAISE FND_API.G_EXC_ERROR;
910: ELSIF l_sy_reas_cds_row.reason_type = 2 AND
911: l_qty_rec.trans_qty > 0

Line 913: FND_MESSAGE.SET_NAME('GMI','IC_API_INC_NOT_ALLOWED');

909: RAISE FND_API.G_EXC_ERROR;
910: ELSIF l_sy_reas_cds_row.reason_type = 2 AND
911: l_qty_rec.trans_qty > 0
912: THEN
913: FND_MESSAGE.SET_NAME('GMI','IC_API_INC_NOT_ALLOWED');
914: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
915: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
916: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
917: FND_MSG_PUB.Add;

Line 914: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

910: ELSIF l_sy_reas_cds_row.reason_type = 2 AND
911: l_qty_rec.trans_qty > 0
912: THEN
913: FND_MESSAGE.SET_NAME('GMI','IC_API_INC_NOT_ALLOWED');
914: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
915: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
916: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
917: FND_MSG_PUB.Add;
918: RAISE FND_API.G_EXC_ERROR;

Line 915: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);

911: l_qty_rec.trans_qty > 0
912: THEN
913: FND_MESSAGE.SET_NAME('GMI','IC_API_INC_NOT_ALLOWED');
914: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
915: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
916: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
917: FND_MSG_PUB.Add;
918: RAISE FND_API.G_EXC_ERROR;
919: END IF;

Line 916: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);

912: THEN
913: FND_MESSAGE.SET_NAME('GMI','IC_API_INC_NOT_ALLOWED');
914: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
915: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
916: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
917: FND_MSG_PUB.Add;
918: RAISE FND_API.G_EXC_ERROR;
919: END IF;
920: END IF;

Line 922: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_REASON_CODE');

918: RAISE FND_API.G_EXC_ERROR;
919: END IF;
920: END IF;
921: ELSE
922: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_REASON_CODE');
923: FND_MESSAGE.SET_TOKEN('REASON_CODE',l_qty_rec.reason_code);
924: FND_MSG_PUB.Add;
925: RAISE FND_API.G_EXC_ERROR;
926: END IF;

Line 923: FND_MESSAGE.SET_TOKEN('REASON_CODE',l_qty_rec.reason_code);

919: END IF;
920: END IF;
921: ELSE
922: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_REASON_CODE');
923: FND_MESSAGE.SET_TOKEN('REASON_CODE',l_qty_rec.reason_code);
924: FND_MSG_PUB.Add;
925: RAISE FND_API.G_EXC_ERROR;
926: END IF;
927:

Line 934: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_QTY_NOT_NEG');

930: /* and transfers must be specified positively */
931:
932: IF l_trans_type IN (3,8) AND l_qty_rec.trans_qty <= 0
933: THEN
934: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_QTY_NOT_NEG');
935: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
936: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
937: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
938: FND_MSG_PUB.Add;

Line 935: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

931:
932: IF l_trans_type IN (3,8) AND l_qty_rec.trans_qty <= 0
933: THEN
934: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_QTY_NOT_NEG');
935: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
936: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
937: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
938: FND_MSG_PUB.Add;
939: RAISE FND_API.G_EXC_ERROR;

Line 936: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);

932: IF l_trans_type IN (3,8) AND l_qty_rec.trans_qty <= 0
933: THEN
934: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_QTY_NOT_NEG');
935: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
936: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
937: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
938: FND_MSG_PUB.Add;
939: RAISE FND_API.G_EXC_ERROR;
940: ELSE

Line 937: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);

933: THEN
934: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_QTY_NOT_NEG');
935: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
936: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
937: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
938: FND_MSG_PUB.Add;
939: RAISE FND_API.G_EXC_ERROR;
940: ELSE
941: IF l_qty_rec.trans_qty =0

Line 943: FND_MESSAGE.SET_NAME('GMI','IC_API_ZERO_QTY');

939: RAISE FND_API.G_EXC_ERROR;
940: ELSE
941: IF l_qty_rec.trans_qty =0
942: THEN
943: FND_MESSAGE.SET_NAME('GMI','IC_API_ZERO_QTY');
944: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
945: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
946: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
947: FND_MSG_PUB.Add;

Line 944: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

940: ELSE
941: IF l_qty_rec.trans_qty =0
942: THEN
943: FND_MESSAGE.SET_NAME('GMI','IC_API_ZERO_QTY');
944: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
945: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
946: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
947: FND_MSG_PUB.Add;
948: RAISE FND_API.G_EXC_ERROR;

Line 945: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);

941: IF l_qty_rec.trans_qty =0
942: THEN
943: FND_MESSAGE.SET_NAME('GMI','IC_API_ZERO_QTY');
944: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
945: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
946: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
947: FND_MSG_PUB.Add;
948: RAISE FND_API.G_EXC_ERROR;
949: END IF;

Line 946: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);

942: THEN
943: FND_MESSAGE.SET_NAME('GMI','IC_API_ZERO_QTY');
944: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
945: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
946: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
947: FND_MSG_PUB.Add;
948: RAISE FND_API.G_EXC_ERROR;
949: END IF;
950: END IF;

Line 1022: FND_MESSAGE.SET_NAME('GMI','IC_API_LOCT_ONHAND_EXISTS');

1018: THEN
1019: /* If inventory create there should be no stock at location. */
1020: IF l_ic_loct_inv_row_from.loct_onhand IS NOT NULL
1021: THEN
1022: FND_MESSAGE.SET_NAME('GMI','IC_API_LOCT_ONHAND_EXISTS');
1023: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1024: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1025: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1026: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);

Line 1023: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

1019: /* If inventory create there should be no stock at location. */
1020: IF l_ic_loct_inv_row_from.loct_onhand IS NOT NULL
1021: THEN
1022: FND_MESSAGE.SET_NAME('GMI','IC_API_LOCT_ONHAND_EXISTS');
1023: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1024: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1025: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1026: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1027: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);

Line 1024: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);

1020: IF l_ic_loct_inv_row_from.loct_onhand IS NOT NULL
1021: THEN
1022: FND_MESSAGE.SET_NAME('GMI','IC_API_LOCT_ONHAND_EXISTS');
1023: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1024: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1025: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1026: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1027: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1028: FND_MSG_PUB.Add;

Line 1025: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);

1021: THEN
1022: FND_MESSAGE.SET_NAME('GMI','IC_API_LOCT_ONHAND_EXISTS');
1023: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1024: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1025: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1026: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1027: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1028: FND_MSG_PUB.Add;
1029: RAISE FND_API.G_EXC_ERROR;

Line 1026: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);

1022: FND_MESSAGE.SET_NAME('GMI','IC_API_LOCT_ONHAND_EXISTS');
1023: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1024: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1025: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1026: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1027: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1028: FND_MSG_PUB.Add;
1029: RAISE FND_API.G_EXC_ERROR;
1030: ELSE

Line 1027: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);

1023: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1024: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1025: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1026: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1027: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1028: FND_MSG_PUB.Add;
1029: RAISE FND_API.G_EXC_ERROR;
1030: ELSE
1031: l_qty_rec.lot_status := p_ic_item_mst_row.lot_status;

Line 1053: FND_MESSAGE.SET_NAME('GMI','IC_API_NO_LOCT_ONHAND');

1049: /* BUG#3127824 James Bernard */
1050: /* Modified code so that user is able to move qty even if source whse has NULL qty */
1051: /*IF l_ic_loct_inv_row_from.loct_onhand IS NULL
1052: THEN
1053: FND_MESSAGE.SET_NAME('GMI','IC_API_NO_LOCT_ONHAND');
1054: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1055: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1056: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1057: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);

Line 1054: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

1050: /* Modified code so that user is able to move qty even if source whse has NULL qty */
1051: /*IF l_ic_loct_inv_row_from.loct_onhand IS NULL
1052: THEN
1053: FND_MESSAGE.SET_NAME('GMI','IC_API_NO_LOCT_ONHAND');
1054: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1055: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1056: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1057: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1058: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);

Line 1055: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);

1051: /*IF l_ic_loct_inv_row_from.loct_onhand IS NULL
1052: THEN
1053: FND_MESSAGE.SET_NAME('GMI','IC_API_NO_LOCT_ONHAND');
1054: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1055: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1056: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1057: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1058: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1059: FND_MSG_PUB.Add;

Line 1056: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);

1052: THEN
1053: FND_MESSAGE.SET_NAME('GMI','IC_API_NO_LOCT_ONHAND');
1054: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1055: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1056: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1057: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1058: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1059: FND_MSG_PUB.Add;
1060: RAISE FND_API.G_EXC_ERROR;

Line 1057: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);

1053: FND_MESSAGE.SET_NAME('GMI','IC_API_NO_LOCT_ONHAND');
1054: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1055: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1056: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1057: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1058: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1059: FND_MSG_PUB.Add;
1060: RAISE FND_API.G_EXC_ERROR;
1061: ELSE*/

Line 1058: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);

1054: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1055: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1056: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1057: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1058: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1059: FND_MSG_PUB.Add;
1060: RAISE FND_API.G_EXC_ERROR;
1061: ELSE*/
1062: /*==================================================

Line 1088: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_STATUS_ERR');

1084: IF (l_ic_loct_inv_row_to.loct_onhand IS NULL)
1085: or (NVL(l_ic_loct_inv_row_from.lot_status,' ') = NVL(l_ic_loct_inv_row_to.lot_status,' ')) THEN
1086: l_qty_rec.lot_status := l_ic_loct_inv_row_from.lot_status;
1087: ELSE
1088: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_STATUS_ERR');
1089: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1090: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1091: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1092: FND_MSG_PUB.Add;

Line 1089: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

1085: or (NVL(l_ic_loct_inv_row_from.lot_status,' ') = NVL(l_ic_loct_inv_row_to.lot_status,' ')) THEN
1086: l_qty_rec.lot_status := l_ic_loct_inv_row_from.lot_status;
1087: ELSE
1088: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_STATUS_ERR');
1089: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1090: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1091: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1092: FND_MSG_PUB.Add;
1093: RAISE FND_API.G_EXC_ERROR;

Line 1090: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);

1086: l_qty_rec.lot_status := l_ic_loct_inv_row_from.lot_status;
1087: ELSE
1088: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_STATUS_ERR');
1089: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1090: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1091: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1092: FND_MSG_PUB.Add;
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;

Line 1091: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);

1087: ELSE
1088: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_STATUS_ERR');
1089: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1090: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1091: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1092: FND_MSG_PUB.Add;
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;
1095: ELSIF GMIGUTL.IC$MOVEDIFFSTAT = 1 THEN

Line 1106: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_STATUS_ERR');

1102: IF (nvl(l_ic_loct_inv_row_to.loct_onhand,0) = 0)
1103: or (NVL(l_ic_loct_inv_row_from.lot_status,' ') = NVL(l_ic_loct_inv_row_to.lot_status,' ')) THEN
1104: l_qty_rec.lot_status := l_ic_loct_inv_row_from.lot_status;
1105: ELSE
1106: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_STATUS_ERR');
1107: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1108: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1109: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1110: FND_MSG_PUB.Add;

Line 1107: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

1103: or (NVL(l_ic_loct_inv_row_from.lot_status,' ') = NVL(l_ic_loct_inv_row_to.lot_status,' ')) THEN
1104: l_qty_rec.lot_status := l_ic_loct_inv_row_from.lot_status;
1105: ELSE
1106: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_STATUS_ERR');
1107: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1108: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1109: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1110: FND_MSG_PUB.Add;
1111: RAISE FND_API.G_EXC_ERROR;

Line 1108: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);

1104: l_qty_rec.lot_status := l_ic_loct_inv_row_from.lot_status;
1105: ELSE
1106: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_STATUS_ERR');
1107: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1108: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1109: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1110: FND_MSG_PUB.Add;
1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;

Line 1109: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);

1105: ELSE
1106: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_STATUS_ERR');
1107: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1108: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1109: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1110: FND_MSG_PUB.Add;
1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;
1113: END IF;

Line 1120: FND_MESSAGE.SET_NAME('GMI','IC_API_NO_LOCT_ONHAND');

1116: ELSIF l_trans_type IN (4,9)
1117: THEN
1118: IF l_ic_loct_inv_row_from.loct_onhand IS NULL
1119: THEN
1120: FND_MESSAGE.SET_NAME('GMI','IC_API_NO_LOCT_ONHAND');
1121: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1122: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1123: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1124: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);

Line 1121: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

1117: THEN
1118: IF l_ic_loct_inv_row_from.loct_onhand IS NULL
1119: THEN
1120: FND_MESSAGE.SET_NAME('GMI','IC_API_NO_LOCT_ONHAND');
1121: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1122: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1123: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1124: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1125: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);

Line 1122: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);

1118: IF l_ic_loct_inv_row_from.loct_onhand IS NULL
1119: THEN
1120: FND_MESSAGE.SET_NAME('GMI','IC_API_NO_LOCT_ONHAND');
1121: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1122: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1123: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1124: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1125: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1126: FND_MSG_PUB.Add;

Line 1123: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);

1119: THEN
1120: FND_MESSAGE.SET_NAME('GMI','IC_API_NO_LOCT_ONHAND');
1121: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1122: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1123: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1124: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1125: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1126: FND_MSG_PUB.Add;
1127: RAISE FND_API.G_EXC_ERROR;

Line 1124: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);

1120: FND_MESSAGE.SET_NAME('GMI','IC_API_NO_LOCT_ONHAND');
1121: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1122: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1123: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1124: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1125: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1126: FND_MSG_PUB.Add;
1127: RAISE FND_API.G_EXC_ERROR;
1128: ELSIF l_qty_rec.lot_status = l_ic_loct_inv_row_from.lot_status

Line 1125: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);

1121: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1122: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1123: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1124: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1125: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1126: FND_MSG_PUB.Add;
1127: RAISE FND_API.G_EXC_ERROR;
1128: ELSIF l_qty_rec.lot_status = l_ic_loct_inv_row_from.lot_status
1129: THEN

Line 1130: FND_MESSAGE.SET_NAME('GMI','IC_API_SAME_LOT_STATUS');

1126: FND_MSG_PUB.Add;
1127: RAISE FND_API.G_EXC_ERROR;
1128: ELSIF l_qty_rec.lot_status = l_ic_loct_inv_row_from.lot_status
1129: THEN
1130: FND_MESSAGE.SET_NAME('GMI','IC_API_SAME_LOT_STATUS');
1131: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1132: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1133: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1134: FND_MSG_PUB.Add;

Line 1131: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

1127: RAISE FND_API.G_EXC_ERROR;
1128: ELSIF l_qty_rec.lot_status = l_ic_loct_inv_row_from.lot_status
1129: THEN
1130: FND_MESSAGE.SET_NAME('GMI','IC_API_SAME_LOT_STATUS');
1131: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1132: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1133: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1134: FND_MSG_PUB.Add;
1135: RAISE FND_API.G_EXC_ERROR;

Line 1132: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);

1128: ELSIF l_qty_rec.lot_status = l_ic_loct_inv_row_from.lot_status
1129: THEN
1130: FND_MESSAGE.SET_NAME('GMI','IC_API_SAME_LOT_STATUS');
1131: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1132: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1133: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1134: FND_MSG_PUB.Add;
1135: RAISE FND_API.G_EXC_ERROR;
1136: ELSIF l_qty_rec.lot_status = p_ic_item_mst_row.lot_status

Line 1133: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);

1129: THEN
1130: FND_MESSAGE.SET_NAME('GMI','IC_API_SAME_LOT_STATUS');
1131: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1132: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1133: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1134: FND_MSG_PUB.Add;
1135: RAISE FND_API.G_EXC_ERROR;
1136: ELSIF l_qty_rec.lot_status = p_ic_item_mst_row.lot_status
1137: THEN

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

1140: IF GMIGUTL.v_lot_status (l_qty_rec.lot_status, l_ic_lots_sts_row)
1141: THEN
1142: NULL;
1143: ELSE
1144: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_STATUS');
1145: FND_MESSAGE.SET_TOKEN('LOT_STATUS',l_qty_rec.lot_status);
1146: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1147: FND_MSG_PUB.Add;
1148: RAISE FND_API.G_EXC_ERROR;

Line 1145: FND_MESSAGE.SET_TOKEN('LOT_STATUS',l_qty_rec.lot_status);

1141: THEN
1142: NULL;
1143: ELSE
1144: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_STATUS');
1145: FND_MESSAGE.SET_TOKEN('LOT_STATUS',l_qty_rec.lot_status);
1146: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1147: FND_MSG_PUB.Add;
1148: RAISE FND_API.G_EXC_ERROR;
1149: END IF;

Line 1146: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

1142: NULL;
1143: ELSE
1144: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_STATUS');
1145: FND_MESSAGE.SET_TOKEN('LOT_STATUS',l_qty_rec.lot_status);
1146: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1147: FND_MSG_PUB.Add;
1148: RAISE FND_API.G_EXC_ERROR;
1149: END IF;
1150: END If;

Line 1160: FND_MESSAGE.SET_NAME('GMI','IC_API_UNPOSTED_JNL_LOT_STATUS');

1156: , p_location => l_qty_rec.from_location
1157: , p_lot_status => l_qty_rec.lot_status
1158: )
1159: THEN
1160: FND_MESSAGE.SET_NAME('GMI','IC_API_UNPOSTED_JNL_LOT_STATUS');
1161: FND_MESSAGE.SET_TOKEN('LOT_STATUS',l_qty_rec.lot_status);
1162: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1163: FND_MSG_PUB.Add;
1164: RAISE FND_API.G_EXC_ERROR;

Line 1161: FND_MESSAGE.SET_TOKEN('LOT_STATUS',l_qty_rec.lot_status);

1157: , p_lot_status => l_qty_rec.lot_status
1158: )
1159: THEN
1160: FND_MESSAGE.SET_NAME('GMI','IC_API_UNPOSTED_JNL_LOT_STATUS');
1161: FND_MESSAGE.SET_TOKEN('LOT_STATUS',l_qty_rec.lot_status);
1162: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1163: FND_MSG_PUB.Add;
1164: RAISE FND_API.G_EXC_ERROR;
1165: END IF;

Line 1162: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

1158: )
1159: THEN
1160: FND_MESSAGE.SET_NAME('GMI','IC_API_UNPOSTED_JNL_LOT_STATUS');
1161: FND_MESSAGE.SET_TOKEN('LOT_STATUS',l_qty_rec.lot_status);
1162: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1163: FND_MSG_PUB.Add;
1164: RAISE FND_API.G_EXC_ERROR;
1165: END IF;
1166: ELSE

Line 1170: FND_MESSAGE.SET_NAME('GMI','IC_API_NO_LOT_ONHAND');

1166: ELSE
1167: /* For grade changes there should be a non-zero balance */
1168: IF NVL(l_onhand,0) = 0
1169: THEN
1170: FND_MESSAGE.SET_NAME('GMI','IC_API_NO_LOT_ONHAND');
1171: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1172: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1173: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1174: FND_MSG_PUB.Add;

Line 1171: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

1167: /* For grade changes there should be a non-zero balance */
1168: IF NVL(l_onhand,0) = 0
1169: THEN
1170: FND_MESSAGE.SET_NAME('GMI','IC_API_NO_LOT_ONHAND');
1171: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1172: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1173: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1174: FND_MSG_PUB.Add;
1175: RAISE FND_API.G_EXC_ERROR;

Line 1172: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);

1168: IF NVL(l_onhand,0) = 0
1169: THEN
1170: FND_MESSAGE.SET_NAME('GMI','IC_API_NO_LOT_ONHAND');
1171: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1172: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1173: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1174: FND_MSG_PUB.Add;
1175: RAISE FND_API.G_EXC_ERROR;
1176: END IF;

Line 1173: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);

1169: THEN
1170: FND_MESSAGE.SET_NAME('GMI','IC_API_NO_LOT_ONHAND');
1171: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1172: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1173: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1174: FND_MSG_PUB.Add;
1175: RAISE FND_API.G_EXC_ERROR;
1176: END IF;
1177: END IF;

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

1182: IF l_qty_rec.item_um <> p_ic_item_mst_row.item_um
1183: THEN
1184: IF NOT GMA_VALID_GRP.Validate_um(l_qty_rec.item_um)
1185: THEN
1186: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');
1187: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1188: FND_MESSAGE.SET_TOKEN('UOM',l_qty_rec.item_um);
1189: FND_MSG_PUB.Add;
1190: RAISE FND_API.G_EXC_ERROR;

Line 1187: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

1183: THEN
1184: IF NOT GMA_VALID_GRP.Validate_um(l_qty_rec.item_um)
1185: THEN
1186: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');
1187: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1188: FND_MESSAGE.SET_TOKEN('UOM',l_qty_rec.item_um);
1189: FND_MSG_PUB.Add;
1190: RAISE FND_API.G_EXC_ERROR;
1191: END IF;

Line 1188: FND_MESSAGE.SET_TOKEN('UOM',l_qty_rec.item_um);

1184: IF NOT GMA_VALID_GRP.Validate_um(l_qty_rec.item_um)
1185: THEN
1186: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');
1187: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1188: FND_MESSAGE.SET_TOKEN('UOM',l_qty_rec.item_um);
1189: FND_MSG_PUB.Add;
1190: RAISE FND_API.G_EXC_ERROR;
1191: END IF;
1192: END IF;

Line 1221: FND_MESSAGE.SET_NAME('GMI','IC_API_UOM_CONVERSION_ERROR');

1217: );
1218: /* Negative quantity indicates UoM conversion failure */
1219: IF (l_qty_rec.trans_qty < 0)
1220: THEN
1221: FND_MESSAGE.SET_NAME('GMI','IC_API_UOM_CONVERSION_ERROR');
1222: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1223: FND_MESSAGE.SET_TOKEN('FROM_UOM',l_qty_rec.item_um);
1224: FND_MESSAGE.SET_TOKEN('TO_UOM',p_ic_item_mst_row.item_um);
1225: FND_MSG_PUB.Add;

Line 1222: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

1218: /* Negative quantity indicates UoM conversion failure */
1219: IF (l_qty_rec.trans_qty < 0)
1220: THEN
1221: FND_MESSAGE.SET_NAME('GMI','IC_API_UOM_CONVERSION_ERROR');
1222: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1223: FND_MESSAGE.SET_TOKEN('FROM_UOM',l_qty_rec.item_um);
1224: FND_MESSAGE.SET_TOKEN('TO_UOM',p_ic_item_mst_row.item_um);
1225: FND_MSG_PUB.Add;
1226: RAISE FND_API.G_EXC_ERROR;

Line 1223: FND_MESSAGE.SET_TOKEN('FROM_UOM',l_qty_rec.item_um);

1219: IF (l_qty_rec.trans_qty < 0)
1220: THEN
1221: FND_MESSAGE.SET_NAME('GMI','IC_API_UOM_CONVERSION_ERROR');
1222: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1223: FND_MESSAGE.SET_TOKEN('FROM_UOM',l_qty_rec.item_um);
1224: FND_MESSAGE.SET_TOKEN('TO_UOM',p_ic_item_mst_row.item_um);
1225: FND_MSG_PUB.Add;
1226: RAISE FND_API.G_EXC_ERROR;
1227: ELSE

Line 1224: FND_MESSAGE.SET_TOKEN('TO_UOM',p_ic_item_mst_row.item_um);

1220: THEN
1221: FND_MESSAGE.SET_NAME('GMI','IC_API_UOM_CONVERSION_ERROR');
1222: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1223: FND_MESSAGE.SET_TOKEN('FROM_UOM',l_qty_rec.item_um);
1224: FND_MESSAGE.SET_TOKEN('TO_UOM',p_ic_item_mst_row.item_um);
1225: FND_MSG_PUB.Add;
1226: RAISE FND_API.G_EXC_ERROR;
1227: ELSE
1228: l_qty_rec.item_um :=p_ic_item_mst_row.item_um;

Line 1316: FND_MESSAGE.SET_NAME('GMI','IC_API_UOM_CONVERSION_ERROR');

1312: );
1313: /* Negative quantity indicates UoM conversion failure */
1314: IF (l_qty2 < 0)
1315: THEN
1316: FND_MESSAGE.SET_NAME('GMI','IC_API_UOM_CONVERSION_ERROR');
1317: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1318: FND_MESSAGE.SET_TOKEN('FROM_UOM',p_ic_item_mst_row.item_um);
1319: FND_MESSAGE.SET_TOKEN('TO_UOM',p_ic_item_mst_row.item_um2);
1320: FND_MSG_PUB.Add;

Line 1317: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

1313: /* Negative quantity indicates UoM conversion failure */
1314: IF (l_qty2 < 0)
1315: THEN
1316: FND_MESSAGE.SET_NAME('GMI','IC_API_UOM_CONVERSION_ERROR');
1317: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1318: FND_MESSAGE.SET_TOKEN('FROM_UOM',p_ic_item_mst_row.item_um);
1319: FND_MESSAGE.SET_TOKEN('TO_UOM',p_ic_item_mst_row.item_um2);
1320: FND_MSG_PUB.Add;
1321: RAISE FND_API.G_EXC_ERROR;

Line 1318: FND_MESSAGE.SET_TOKEN('FROM_UOM',p_ic_item_mst_row.item_um);

1314: IF (l_qty2 < 0)
1315: THEN
1316: FND_MESSAGE.SET_NAME('GMI','IC_API_UOM_CONVERSION_ERROR');
1317: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1318: FND_MESSAGE.SET_TOKEN('FROM_UOM',p_ic_item_mst_row.item_um);
1319: FND_MESSAGE.SET_TOKEN('TO_UOM',p_ic_item_mst_row.item_um2);
1320: FND_MSG_PUB.Add;
1321: RAISE FND_API.G_EXC_ERROR;
1322: END IF;

Line 1319: FND_MESSAGE.SET_TOKEN('TO_UOM',p_ic_item_mst_row.item_um2);

1315: THEN
1316: FND_MESSAGE.SET_NAME('GMI','IC_API_UOM_CONVERSION_ERROR');
1317: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1318: FND_MESSAGE.SET_TOKEN('FROM_UOM',p_ic_item_mst_row.item_um);
1319: FND_MESSAGE.SET_TOKEN('TO_UOM',p_ic_item_mst_row.item_um2);
1320: FND_MSG_PUB.Add;
1321: RAISE FND_API.G_EXC_ERROR;
1322: END IF;
1323: /* Reverse quantity sign if reversed above */

Line 1361: FND_MESSAGE.SET_NAME('GMI','IC_API_UOM_CONVERSION_ERROR');

1357: );
1358: /* Negative quantity indicates UoM conversion failure */
1359: IF (l_qty_rec.trans_qty2 < 0)
1360: THEN
1361: FND_MESSAGE.SET_NAME('GMI','IC_API_UOM_CONVERSION_ERROR');
1362: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1363: FND_MESSAGE.SET_TOKEN('FROM_UOM',l_qty_rec.item_um2);
1364: FND_MESSAGE.SET_TOKEN('TO_UOM',p_ic_item_mst_row.item_um2);
1365: FND_MSG_PUB.Add;

Line 1362: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

1358: /* Negative quantity indicates UoM conversion failure */
1359: IF (l_qty_rec.trans_qty2 < 0)
1360: THEN
1361: FND_MESSAGE.SET_NAME('GMI','IC_API_UOM_CONVERSION_ERROR');
1362: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1363: FND_MESSAGE.SET_TOKEN('FROM_UOM',l_qty_rec.item_um2);
1364: FND_MESSAGE.SET_TOKEN('TO_UOM',p_ic_item_mst_row.item_um2);
1365: FND_MSG_PUB.Add;
1366: RAISE FND_API.G_EXC_ERROR;

Line 1363: FND_MESSAGE.SET_TOKEN('FROM_UOM',l_qty_rec.item_um2);

1359: IF (l_qty_rec.trans_qty2 < 0)
1360: THEN
1361: FND_MESSAGE.SET_NAME('GMI','IC_API_UOM_CONVERSION_ERROR');
1362: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1363: FND_MESSAGE.SET_TOKEN('FROM_UOM',l_qty_rec.item_um2);
1364: FND_MESSAGE.SET_TOKEN('TO_UOM',p_ic_item_mst_row.item_um2);
1365: FND_MSG_PUB.Add;
1366: RAISE FND_API.G_EXC_ERROR;
1367: ELSE

Line 1364: FND_MESSAGE.SET_TOKEN('TO_UOM',p_ic_item_mst_row.item_um2);

1360: THEN
1361: FND_MESSAGE.SET_NAME('GMI','IC_API_UOM_CONVERSION_ERROR');
1362: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1363: FND_MESSAGE.SET_TOKEN('FROM_UOM',l_qty_rec.item_um2);
1364: FND_MESSAGE.SET_TOKEN('TO_UOM',p_ic_item_mst_row.item_um2);
1365: FND_MSG_PUB.Add;
1366: RAISE FND_API.G_EXC_ERROR;
1367: ELSE
1368: l_qty_rec.item_um2 :=p_ic_item_mst_row.item_um2;

Line 1395: FND_MESSAGE.SET_NAME('GMI','IC_API_QTY_TOLERANCE_ERROR');

1391: ABS(l_qty2) * (1 + p_ic_item_mst_row.deviation_hi)) OR
1392: (ABS(l_qty_rec.trans_qty2) <
1393: ABS(l_qty2) * (1 - p_ic_item_mst_row.deviation_lo))
1394: THEN
1395: FND_MESSAGE.SET_NAME('GMI','IC_API_QTY_TOLERANCE_ERROR');
1396: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1397: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1398: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1399: FND_MSG_PUB.Add;

Line 1396: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

1392: (ABS(l_qty_rec.trans_qty2) <
1393: ABS(l_qty2) * (1 - p_ic_item_mst_row.deviation_lo))
1394: THEN
1395: FND_MESSAGE.SET_NAME('GMI','IC_API_QTY_TOLERANCE_ERROR');
1396: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1397: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1398: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1399: FND_MSG_PUB.Add;
1400: RAISE FND_API.G_EXC_ERROR;

Line 1397: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);

1393: ABS(l_qty2) * (1 - p_ic_item_mst_row.deviation_lo))
1394: THEN
1395: FND_MESSAGE.SET_NAME('GMI','IC_API_QTY_TOLERANCE_ERROR');
1396: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1397: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1398: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1399: FND_MSG_PUB.Add;
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;

Line 1398: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);

1394: THEN
1395: FND_MESSAGE.SET_NAME('GMI','IC_API_QTY_TOLERANCE_ERROR');
1396: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1397: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1398: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1399: FND_MSG_PUB.Add;
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;
1402: END IF;

Line 1447: FND_MESSAGE.SET_NAME('GMI','IC_API_NEG_QTY_NOT_ALLOWED');

1443: ( (l_trans_type IN (3,8))
1444: AND ((nvl(l_ic_loct_inv_row_from.loct_onhand,0) - l_qty_rec.trans_qty - l_other_lines_qty) < 0)
1445: )
1446: ) THEN
1447: FND_MESSAGE.SET_NAME('GMI','IC_API_NEG_QTY_NOT_ALLOWED');
1448: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1449: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1450: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1451: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);

Line 1448: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

1444: AND ((nvl(l_ic_loct_inv_row_from.loct_onhand,0) - l_qty_rec.trans_qty - l_other_lines_qty) < 0)
1445: )
1446: ) THEN
1447: FND_MESSAGE.SET_NAME('GMI','IC_API_NEG_QTY_NOT_ALLOWED');
1448: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1449: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1450: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1451: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1452: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);

Line 1449: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);

1445: )
1446: ) THEN
1447: FND_MESSAGE.SET_NAME('GMI','IC_API_NEG_QTY_NOT_ALLOWED');
1448: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1449: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1450: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1451: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1452: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1453: FND_MSG_PUB.Add;

Line 1450: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);

1446: ) THEN
1447: FND_MESSAGE.SET_NAME('GMI','IC_API_NEG_QTY_NOT_ALLOWED');
1448: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1449: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1450: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1451: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1452: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1453: FND_MSG_PUB.Add;
1454: RAISE FND_API.G_EXC_ERROR;

Line 1451: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);

1447: FND_MESSAGE.SET_NAME('GMI','IC_API_NEG_QTY_NOT_ALLOWED');
1448: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1449: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1450: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1451: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1452: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1453: FND_MSG_PUB.Add;
1454: RAISE FND_API.G_EXC_ERROR;
1455: END IF;

Line 1452: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);

1448: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1449: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1450: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1451: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1452: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1453: FND_MSG_PUB.Add;
1454: RAISE FND_API.G_EXC_ERROR;
1455: END IF;
1456: END IF;

Line 1463: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_INDIVISIBLE');

1459: IF (p_ic_item_mst_row.lot_indivisible = 1) AND
1460: (l_trans_type IN (3,8)) AND
1461: (l_ic_loct_inv_row_from.loct_onhand <> l_qty_rec.trans_qty)
1462: THEN
1463: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_INDIVISIBLE');
1464: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1465: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1466: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1467: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);

Line 1464: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

1460: (l_trans_type IN (3,8)) AND
1461: (l_ic_loct_inv_row_from.loct_onhand <> l_qty_rec.trans_qty)
1462: THEN
1463: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_INDIVISIBLE');
1464: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1465: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1466: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1467: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1468: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);

Line 1465: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);

1461: (l_ic_loct_inv_row_from.loct_onhand <> l_qty_rec.trans_qty)
1462: THEN
1463: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_INDIVISIBLE');
1464: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1465: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1466: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1467: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1468: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1469: FND_MSG_PUB.Add;

Line 1466: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);

1462: THEN
1463: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_INDIVISIBLE');
1464: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1465: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1466: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1467: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1468: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1469: FND_MSG_PUB.Add;
1470: RAISE FND_API.G_EXC_ERROR;

Line 1467: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);

1463: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_INDIVISIBLE');
1464: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1465: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1466: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1467: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1468: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1469: FND_MSG_PUB.Add;
1470: RAISE FND_API.G_EXC_ERROR;
1471: END IF;

Line 1468: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);

1464: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1465: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1466: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1467: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1468: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1469: FND_MSG_PUB.Add;
1470: RAISE FND_API.G_EXC_ERROR;
1471: END IF;
1472: IF (l_qty_rec.txn_type IN ('GRD','STS','TRN')) THEN

Line 1494: FND_MESSAGE.SET_NAME('GMI','GMI_API_CHARGE_ACCT');

1490: x_ic_adjs_jnl_row1.acct_id := NULL;
1491: ELSIF ( (l_qty_rec.acctg_unit_no IS NULL)
1492: OR (l_qty_rec.acct_no IS NULL)
1493: ) THEN
1494: FND_MESSAGE.SET_NAME('GMI','GMI_API_CHARGE_ACCT');
1495: FND_MSG_PUB.Add;
1496: RAISE FND_API.G_EXC_ERROR;
1497: ELSE
1498: /* *********************************************************