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.GMIVQTY dependencies on IC_LOCT_INV

Line 491: l_ic_loct_inv_row_from ic_loct_inv%ROWTYPE;

487: )
488: IS
489: l_qty_rec GMIGAPI.qty_rec_typ;
490: l_ic_whse_mst_rec ic_whse_mst%ROWTYPE;
491: l_ic_loct_inv_row_from ic_loct_inv%ROWTYPE;
492: l_ic_loct_inv_row_to ic_loct_inv%ROWTYPE;
493: l_sy_reas_cds_row sy_reas_cds%ROWTYPE;
494: l_qc_grad_mst_row qc_grad_mst%ROWTYPE;
495: l_ic_lots_sts_row ic_lots_sts%ROWTYPE;

Line 492: l_ic_loct_inv_row_to ic_loct_inv%ROWTYPE;

488: IS
489: l_qty_rec GMIGAPI.qty_rec_typ;
490: l_ic_whse_mst_rec ic_whse_mst%ROWTYPE;
491: l_ic_loct_inv_row_from ic_loct_inv%ROWTYPE;
492: l_ic_loct_inv_row_to ic_loct_inv%ROWTYPE;
493: l_sy_reas_cds_row sy_reas_cds%ROWTYPE;
494: l_qc_grad_mst_row qc_grad_mst%ROWTYPE;
495: l_ic_lots_sts_row ic_lots_sts%ROWTYPE;
496: l_qty2 NUMBER;

Line 521: FROM ic_loct_inv

517: l_other_lines_qty NUMBER := 0;
518: l_from_whse_co_code VARCHAR2(4);
519: CURSOR Cur_get_onhand_for_grade IS
520: SELECT sum(loct_onhand),sum(loct_onhand2)
521: FROM ic_loct_inv
522: WHERE item_id = p_ic_item_mst_row.item_id
523: AND lot_id = p_ic_lots_mst_row.lot_id;
524:
525: --BEGIN BUG#3171345

Line 964: , x_ic_loct_inv_row =>l_ic_loct_inv_row_from

960: ( p_item_id => p_ic_item_mst_row.item_id
961: , p_whse_code =>l_qty_rec.from_whse_code
962: , p_lot_id =>p_ic_lots_mst_row.lot_id
963: , p_location =>l_qty_rec.from_location
964: , x_ic_loct_inv_row =>l_ic_loct_inv_row_from
965: );
966: /* *************************************************************
967: Jalaj Srivastava Bug 2635964
968: Need to populate only for status immediate transactions.

Line 971: l_onhand := l_ic_loct_inv_row_from.loct_onhand;

967: Jalaj Srivastava Bug 2635964
968: Need to populate only for status immediate transactions.
969: ************************************************************* */
970: IF (l_trans_type = 4) THEN
971: l_onhand := l_ic_loct_inv_row_from.loct_onhand;
972: l_onhand2 := l_ic_loct_inv_row_from.loct_onhand2;
973: END IF;
974: ELSIF l_trans_type IN (3,8)
975: THEN

Line 972: l_onhand2 := l_ic_loct_inv_row_from.loct_onhand2;

968: Need to populate only for status immediate transactions.
969: ************************************************************* */
970: IF (l_trans_type = 4) THEN
971: l_onhand := l_ic_loct_inv_row_from.loct_onhand;
972: l_onhand2 := l_ic_loct_inv_row_from.loct_onhand2;
973: END IF;
974: ELSIF l_trans_type IN (3,8)
975: THEN
976: GMIGUTL.get_loct_inv

Line 981: , x_ic_loct_inv_row =>l_ic_loct_inv_row_from

977: ( p_item_id => p_ic_item_mst_row.item_id
978: , p_whse_code =>l_qty_rec.from_whse_code
979: , p_lot_id =>p_ic_lots_mst_row.lot_id
980: , p_location =>l_qty_rec.from_location
981: , x_ic_loct_inv_row =>l_ic_loct_inv_row_from
982: );
983: GMIGUTL.get_loct_inv
984: ( p_item_id => p_ic_item_mst_row.item_id
985: , p_whse_code =>l_qty_rec.to_whse_code

Line 988: , x_ic_loct_inv_row =>l_ic_loct_inv_row_to

984: ( p_item_id => p_ic_item_mst_row.item_id
985: , p_whse_code =>l_qty_rec.to_whse_code
986: , p_lot_id =>p_ic_lots_mst_row.lot_id
987: , p_location =>l_qty_rec.to_location
988: , x_ic_loct_inv_row =>l_ic_loct_inv_row_to
989: );
990: ELSIF l_trans_type IN (5,10) THEN
991: /* *************************************************************
992: Jalaj Srivastava Bug 2635964

Line 998: ic_loct_inv using GMIVDBL.ic_loct_inv_select which uses a

994: The grade change affects the lot at all warehouse/location.
995: To get onhand we need to sum up the onhands at all the
996: warehouse/locations where the lot exists.
997: Removed the code here which was seleting directly from
998: ic_loct_inv using GMIVDBL.ic_loct_inv_select which uses a
999: rownum? to restrict rows to 1.
1000: ************************************************************* */
1001: OPEN Cur_get_onhand_for_grade;
1002: FETCH Cur_get_onhand_for_grade INTO l_onhand,l_onhand2;

Line 1015: l_original_lot_status := l_ic_loct_inv_row_from.lot_status;

1011: /* Hang onto original status and grade as we'll need them */
1012: /* when we set up the output journal rows */
1013:
1014: l_original_qc_grade := p_ic_lots_mst_row.qc_grade;
1015: l_original_lot_status := l_ic_loct_inv_row_from.lot_status;
1016:
1017: IF l_trans_type IN (1,6)
1018: THEN
1019: /* If inventory create there should be no stock at location. */

Line 1020: IF l_ic_loct_inv_row_from.loct_onhand IS NOT NULL

1016:
1017: IF l_trans_type IN (1,6)
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);

Line 1037: IF l_ic_loct_inv_row_from.loct_onhand IS NULL

1033: END IF;
1034: ELSIF l_trans_type IN (2,7)
1035: THEN
1036: /* If adjusting there might or might not be stock */
1037: IF l_ic_loct_inv_row_from.loct_onhand IS NULL
1038: THEN
1039: l_qty_rec.lot_status := p_ic_item_mst_row.lot_status;
1040: l_qty_rec.qc_grade := p_ic_item_mst_row.qc_grade;
1041: ELSE

Line 1042: l_qty_rec.lot_status := l_ic_loct_inv_row_from.lot_status;

1038: THEN
1039: l_qty_rec.lot_status := p_ic_item_mst_row.lot_status;
1040: l_qty_rec.qc_grade := p_ic_item_mst_row.qc_grade;
1041: ELSE
1042: l_qty_rec.lot_status := l_ic_loct_inv_row_from.lot_status;
1043: l_qty_rec.qc_grade := p_ic_lots_mst_row.qc_grade;
1044: END IF;
1045: ELSIF l_trans_type IN (3,8)
1046: THEN

Line 1051: /*IF l_ic_loct_inv_row_from.loct_onhand IS NULL

1047: /* If moving stock then there should be some at the source but */
1048: /* not necessarilly at the target. */
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);

Line 1066: IF p_ic_item_mst_row.status_ctl = 1 AND l_ic_loct_inv_row_from.lot_status IS NULL THEN

1062: /*==================================================
1063: 27/Dec/2001 J.DiIorio Bug#2117575 - 11.5.1I
1064: ================================================*/
1065: --BEGIN BUG James Bernard3171345
1066: IF p_ic_item_mst_row.status_ctl = 1 AND l_ic_loct_inv_row_from.lot_status IS NULL THEN
1067: --Check first if there is any/zero qty in the to whse ie destination whse.
1068: IF l_ic_loct_inv_row_to.lot_status IS NULL THEN
1069: OPEN Cur_get_status;
1070: FETCH Cur_get_status INTO l_ic_loct_inv_row_from.lot_status;

Line 1068: IF l_ic_loct_inv_row_to.lot_status IS NULL THEN

1064: ================================================*/
1065: --BEGIN BUG James Bernard3171345
1066: IF p_ic_item_mst_row.status_ctl = 1 AND l_ic_loct_inv_row_from.lot_status IS NULL THEN
1067: --Check first if there is any/zero qty in the to whse ie destination whse.
1068: IF l_ic_loct_inv_row_to.lot_status IS NULL THEN
1069: OPEN Cur_get_status;
1070: FETCH Cur_get_status INTO l_ic_loct_inv_row_from.lot_status;
1071: l_original_lot_status:=l_ic_loct_inv_row_from.lot_status;
1072: CLOSE Cur_get_status;

Line 1070: FETCH Cur_get_status INTO l_ic_loct_inv_row_from.lot_status;

1066: IF p_ic_item_mst_row.status_ctl = 1 AND l_ic_loct_inv_row_from.lot_status IS NULL THEN
1067: --Check first if there is any/zero qty in the to whse ie destination whse.
1068: IF l_ic_loct_inv_row_to.lot_status IS NULL THEN
1069: OPEN Cur_get_status;
1070: FETCH Cur_get_status INTO l_ic_loct_inv_row_from.lot_status;
1071: l_original_lot_status:=l_ic_loct_inv_row_from.lot_status;
1072: CLOSE Cur_get_status;
1073: ELSE
1074: --There is zero/any qty in destination whse ..assign that status to the source as well.

Line 1071: l_original_lot_status:=l_ic_loct_inv_row_from.lot_status;

1067: --Check first if there is any/zero qty in the to whse ie destination whse.
1068: IF l_ic_loct_inv_row_to.lot_status IS NULL THEN
1069: OPEN Cur_get_status;
1070: FETCH Cur_get_status INTO l_ic_loct_inv_row_from.lot_status;
1071: l_original_lot_status:=l_ic_loct_inv_row_from.lot_status;
1072: CLOSE Cur_get_status;
1073: ELSE
1074: --There is zero/any qty in destination whse ..assign that status to the source as well.
1075: l_ic_loct_inv_row_from.lot_status:=l_ic_loct_inv_row_to.lot_status;

Line 1075: l_ic_loct_inv_row_from.lot_status:=l_ic_loct_inv_row_to.lot_status;

1071: l_original_lot_status:=l_ic_loct_inv_row_from.lot_status;
1072: CLOSE Cur_get_status;
1073: ELSE
1074: --There is zero/any qty in destination whse ..assign that status to the source as well.
1075: l_ic_loct_inv_row_from.lot_status:=l_ic_loct_inv_row_to.lot_status;
1076: l_original_lot_status:=l_ic_loct_inv_row_to.lot_status;
1077: END IF;
1078: END IF;
1079: --END BUG#3171345

Line 1076: l_original_lot_status:=l_ic_loct_inv_row_to.lot_status;

1072: CLOSE Cur_get_status;
1073: ELSE
1074: --There is zero/any qty in destination whse ..assign that status to the source as well.
1075: l_ic_loct_inv_row_from.lot_status:=l_ic_loct_inv_row_to.lot_status;
1076: l_original_lot_status:=l_ic_loct_inv_row_to.lot_status;
1077: END IF;
1078: END IF;
1079: --END BUG#3171345
1080: -- BEGIN BUG#2354190/2354168 Sastry/Ravi

Line 1084: IF (l_ic_loct_inv_row_to.loct_onhand IS NULL)

1080: -- BEGIN BUG#2354190/2354168 Sastry/Ravi
1081: -- Modified the code to handle different cases when profile
1082: -- option IC$MOVEDIFFSTAT is set to different values.
1083: IF GMIGUTL.IC$MOVEDIFFSTAT =0 THEN
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');

Line 1085: or (NVL(l_ic_loct_inv_row_from.lot_status,' ') = NVL(l_ic_loct_inv_row_to.lot_status,' ')) THEN

1081: -- Modified the code to handle different cases when profile
1082: -- option IC$MOVEDIFFSTAT is set to different values.
1083: IF GMIGUTL.IC$MOVEDIFFSTAT =0 THEN
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);

Line 1086: l_qty_rec.lot_status := l_ic_loct_inv_row_from.lot_status;

1082: -- option IC$MOVEDIFFSTAT is set to different values.
1083: IF GMIGUTL.IC$MOVEDIFFSTAT =0 THEN
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);

Line 1096: IF (l_ic_loct_inv_row_to.loct_onhand IS NULL) THEN

1092: FND_MSG_PUB.Add;
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;
1095: ELSIF GMIGUTL.IC$MOVEDIFFSTAT = 1 THEN
1096: IF (l_ic_loct_inv_row_to.loct_onhand IS NULL) THEN
1097: l_qty_rec.lot_status := l_ic_loct_inv_row_FROM.lot_status;
1098: ELSE
1099: l_qty_rec.lot_status := l_ic_loct_inv_row_TO.lot_status;
1100: END IF;

Line 1097: l_qty_rec.lot_status := l_ic_loct_inv_row_FROM.lot_status;

1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;
1095: ELSIF GMIGUTL.IC$MOVEDIFFSTAT = 1 THEN
1096: IF (l_ic_loct_inv_row_to.loct_onhand IS NULL) THEN
1097: l_qty_rec.lot_status := l_ic_loct_inv_row_FROM.lot_status;
1098: ELSE
1099: l_qty_rec.lot_status := l_ic_loct_inv_row_TO.lot_status;
1100: END IF;
1101: ELSIF GMIGUTL.IC$MOVEDIFFSTAT =2 THEN

Line 1099: l_qty_rec.lot_status := l_ic_loct_inv_row_TO.lot_status;

1095: ELSIF GMIGUTL.IC$MOVEDIFFSTAT = 1 THEN
1096: IF (l_ic_loct_inv_row_to.loct_onhand IS NULL) THEN
1097: l_qty_rec.lot_status := l_ic_loct_inv_row_FROM.lot_status;
1098: ELSE
1099: l_qty_rec.lot_status := l_ic_loct_inv_row_TO.lot_status;
1100: END IF;
1101: ELSIF GMIGUTL.IC$MOVEDIFFSTAT =2 THEN
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

Line 1102: IF (nvl(l_ic_loct_inv_row_to.loct_onhand,0) = 0)

1098: ELSE
1099: l_qty_rec.lot_status := l_ic_loct_inv_row_TO.lot_status;
1100: END IF;
1101: ELSIF GMIGUTL.IC$MOVEDIFFSTAT =2 THEN
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');

Line 1103: or (NVL(l_ic_loct_inv_row_from.lot_status,' ') = NVL(l_ic_loct_inv_row_to.lot_status,' ')) THEN

1099: l_qty_rec.lot_status := l_ic_loct_inv_row_TO.lot_status;
1100: END IF;
1101: ELSIF GMIGUTL.IC$MOVEDIFFSTAT =2 THEN
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);

Line 1104: l_qty_rec.lot_status := l_ic_loct_inv_row_from.lot_status;

1100: END IF;
1101: ELSIF GMIGUTL.IC$MOVEDIFFSTAT =2 THEN
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);

Line 1118: IF l_ic_loct_inv_row_from.loct_onhand IS NULL

1114: -- END IF; BUG#3127824 James Bernard
1115: -- END BUG#2354190/2354168
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);

Line 1128: ELSIF l_qty_rec.lot_status = l_ic_loct_inv_row_from.lot_status

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
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);

Line 1246: (l_qty_rec.trans_qty + l_ic_loct_inv_row_from.loct_onhand) = 0 )

1242: /* Bug 2206335 */
1243: /* Do not call the uom conversion routine if the user is trying to
1244: zero out the quantity or move entire quantity */
1245: IF ( (l_trans_type IN (2,7)) AND
1246: (l_qty_rec.trans_qty + l_ic_loct_inv_row_from.loct_onhand) = 0 )
1247: THEN
1248: -- BEGIN BUG#2861715 Sastry
1249: IF (p_ic_item_mst_row.dualum_ind = 2) THEN
1250: IF (UPPER(l_qty_rec.move_entire_qty) = 'Y') THEN

Line 1251: l_qty2 := l_ic_loct_inv_row_from.loct_onhand2 * -1;

1247: THEN
1248: -- BEGIN BUG#2861715 Sastry
1249: IF (p_ic_item_mst_row.dualum_ind = 2) THEN
1250: IF (UPPER(l_qty_rec.move_entire_qty) = 'Y') THEN
1251: l_qty2 := l_ic_loct_inv_row_from.loct_onhand2 * -1;
1252: l_qty_rec.trans_qty2 :=l_qty2;
1253: l_check_deviation := 0;
1254: ELSE
1255: l_qty2 := GMICUOM.uom_conversion

Line 1266: l_qty2 := l_ic_loct_inv_row_from.loct_onhand2 * -1;

1262: );
1263: l_check_deviation := 1;
1264: END IF;
1265: ELSE
1266: l_qty2 := l_ic_loct_inv_row_from.loct_onhand2 * -1;
1267: l_qty_rec.trans_qty2 :=l_qty2;
1268: l_check_deviation := 0;
1269: END IF;
1270: -- END BUG#2861715

Line 1272: (l_qty_rec.trans_qty - l_ic_loct_inv_row_from.loct_onhand) = 0 )

1268: l_check_deviation := 0;
1269: END IF;
1270: -- END BUG#2861715
1271: ELSIF( (l_trans_type IN (3,8)) AND
1272: (l_qty_rec.trans_qty - l_ic_loct_inv_row_from.loct_onhand) = 0 )
1273: THEN
1274: -- BEGIN BUG#2861715 Sastry
1275: -- Added code to move the entire Onhand qty2 based on the newly added parameter
1276: IF (p_ic_item_mst_row.dualum_ind = 2) THEN

Line 1278: l_qty2 := l_ic_loct_inv_row_from.loct_onhand2;

1274: -- BEGIN BUG#2861715 Sastry
1275: -- Added code to move the entire Onhand qty2 based on the newly added parameter
1276: IF (p_ic_item_mst_row.dualum_ind = 2) THEN
1277: IF (UPPER(l_qty_rec.move_entire_qty) = 'Y') THEN
1278: l_qty2 := l_ic_loct_inv_row_from.loct_onhand2;
1279: l_qty_rec.trans_qty2 :=l_qty2;
1280: l_check_deviation := 0;
1281: ELSE
1282: l_qty2 := GMICUOM.uom_conversion

Line 1293: l_qty2 := l_ic_loct_inv_row_from.loct_onhand2;

1289: );
1290: l_check_deviation := 1;
1291: END IF;
1292: ELSE
1293: l_qty2 := l_ic_loct_inv_row_from.loct_onhand2;
1294: l_qty_rec.trans_qty2 :=l_qty2;
1295: l_check_deviation := 0;
1296: END IF;
1297: -- END BUG#2861715

Line 1436: -- l_ic_loct_inv_row_from.loct_onhand is null.

1432: AND a.location = nvl(l_qty_rec.from_location,GMIGUTL.IC$DEFAULT_LOCT);
1433: END IF;-- ( (l_trans_type IN (7,8))
1434: -- Bug 2946031
1435: -- Display negative qty not allowed message correctly if
1436: -- l_ic_loct_inv_row_from.loct_onhand is null.
1437: -- Bug 3127824 Added nvl function to l_ic_loct_inv_row_from.loct_onhand so that negative qty not
1438: -- allowed message is displayed properly when doing move immediate / Journal.
1439: IF ( ( (l_trans_type IN (1,2,6,7))
1440: AND ((nvl(l_ic_loct_inv_row_from.loct_onhand,0) + l_qty_rec.trans_qty + l_other_lines_qty) < 0)

Line 1437: -- Bug 3127824 Added nvl function to l_ic_loct_inv_row_from.loct_onhand so that negative qty not

1433: END IF;-- ( (l_trans_type IN (7,8))
1434: -- Bug 2946031
1435: -- Display negative qty not allowed message correctly if
1436: -- l_ic_loct_inv_row_from.loct_onhand is null.
1437: -- Bug 3127824 Added nvl function to l_ic_loct_inv_row_from.loct_onhand so that negative qty not
1438: -- allowed message is displayed properly when doing move immediate / Journal.
1439: IF ( ( (l_trans_type IN (1,2,6,7))
1440: AND ((nvl(l_ic_loct_inv_row_from.loct_onhand,0) + l_qty_rec.trans_qty + l_other_lines_qty) < 0)
1441: )

Line 1440: AND ((nvl(l_ic_loct_inv_row_from.loct_onhand,0) + l_qty_rec.trans_qty + l_other_lines_qty) < 0)

1436: -- l_ic_loct_inv_row_from.loct_onhand is null.
1437: -- Bug 3127824 Added nvl function to l_ic_loct_inv_row_from.loct_onhand so that negative qty not
1438: -- allowed message is displayed properly when doing move immediate / Journal.
1439: IF ( ( (l_trans_type IN (1,2,6,7))
1440: AND ((nvl(l_ic_loct_inv_row_from.loct_onhand,0) + l_qty_rec.trans_qty + l_other_lines_qty) < 0)
1441: )
1442: OR
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)

Line 1444: AND ((nvl(l_ic_loct_inv_row_from.loct_onhand,0) - l_qty_rec.trans_qty - l_other_lines_qty) < 0)

1440: AND ((nvl(l_ic_loct_inv_row_from.loct_onhand,0) + l_qty_rec.trans_qty + l_other_lines_qty) < 0)
1441: )
1442: OR
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);

Line 1461: (l_ic_loct_inv_row_from.loct_onhand <> l_qty_rec.trans_qty)

1457:
1458: /* Check move quantity if item is lot-indivisble */
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);