APPS.GMI_QUANTITY_PVT dependencies on SY_REAS_CDS

Line 97: l_sy_reas_cds_rec sy_reas_cds%ROWTYPE;

93: l_ic_lots_cpg_rec ic_lots_cpg%ROWTYPE;
94: l_ic_whse_mst_rec ic_whse_mst%ROWTYPE;
95: l_ic_loct_inv_rec_from ic_loct_inv%ROWTYPE;
96: l_ic_loct_inv_rec_to ic_loct_inv%ROWTYPE;
97: l_sy_reas_cds_rec sy_reas_cds%ROWTYPE;
98: l_lot_rec GMI_LOTS_PUB.lot_rec_typ;
99: l_item_id ic_item_mst.item_id%TYPE;
100: l_lot_id ic_lots_mst.lot_id%TYPE;
101: l_qty2 NUMBER;

Line 332: , x_sy_reas_cds => l_sy_reas_cds_rec

328:
329: -- Validate Reason Code
330: GMA_GLOBAL_GRP.Get_Reason_Code
331: ( p_reason_code => l_trans_rec.reason_code
332: , x_sy_reas_cds => l_sy_reas_cds_rec
333: );
334: IF (l_sy_reas_cds_rec.reason_code = ' ')
335: THEN
336: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_REASON_CODE');

Line 334: IF (l_sy_reas_cds_rec.reason_code = ' ')

330: GMA_GLOBAL_GRP.Get_Reason_Code
331: ( p_reason_code => l_trans_rec.reason_code
332: , x_sy_reas_cds => l_sy_reas_cds_rec
333: );
334: IF (l_sy_reas_cds_rec.reason_code = ' ')
335: THEN
336: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_REASON_CODE');
337: FND_MESSAGE.SET_TOKEN('REASON_CODE',l_trans_rec.reason_code);
338: FND_MSG_PUB.Add;

Line 961: IF ((l_sy_reas_cds_rec.reason_type = 1) AND

957:
958: -- Check reason type allows quantity
959: IF (l_trans_type < 4)
960: THEN
961: IF ((l_sy_reas_cds_rec.reason_type = 1) AND
962: (l_trans_rec.trans_qty < 0))
963: THEN
964: FND_MESSAGE.SET_NAME('GMI','IC_API_DEC_NOT_ALLOWED');
965: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);

Line 970: ELSIF ((l_sy_reas_cds_rec.reason_type = 2) AND

966: FND_MESSAGE.SET_TOKEN('LOT_NO',l_trans_rec.lot_no);
967: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_trans_rec.sublot_no);
968: FND_MSG_PUB.Add;
969: RAISE FND_API.G_EXC_ERROR;
970: ELSIF ((l_sy_reas_cds_rec.reason_type = 2) AND
971: (l_trans_rec.trans_qty > 0))
972: THEN
973: FND_MESSAGE.SET_NAME('GMI','IC_API_INC_NOT_ALLOWED');
974: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);