DBA Data[Home] [Help]

APPS.GMI_OM_ALLOC_API_PUB dependencies on IC_LOTS_STS

Line 193: FROM ic_lots_sts

189: CURSOR lot_status_cur(p_lot_status VARCHAR2) IS
190: SELECT nettable_ind
191: ,order_proc_ind
192: ,rejected_ind
193: FROM ic_lots_sts
194: WHERE lot_status = p_lot_status;
195:
196: CURSOR ic_loct_mst_cur(p_location IN VARCHAR2
197: ,p_whse_code IN VARCHAR2) IS

Line 1060: PrintMsg('ERROR - No row in ic_lots_sts');

1056:
1057: IF (lot_status_cur%NOTFOUND)
1058: THEN
1059: CLOSE lot_status_cur;
1060: PrintMsg('ERROR - No row in ic_lots_sts');
1061: l_error_flag := FND_API.G_TRUE;
1062: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_STATUS_NOT_FOUND');
1063: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
1064: FND_MESSAGE.Set_Token('LOT_STATUS', l_loct_inv_rec.lot_status);